Lookup

jl21

New Member
Joined
Nov 21, 2005
Messages
8
I have written the following lookup:

=LOOKUP(J27,{"aincc","ainct","agroc","agrot","abalc","abalt","fallc","fallt","ftsec","ftset"},{"APCIMS Income Capital Return","APCIMS Income Total Return","APCIMS Growth Capital Return","APCIMS Growth Total Return","APCIMS Balanced Capital Return","APCIMS Balanced Total Return","FTSE All Share Capital Return","FTSE All Share Total Return","FTSE 100 Capital Return","FTSE 100 Total Return"})

However, when looking in j27 if aincc is present it always returns APCIMS Balanced Total return and not APCIMS Income Capital Return!!! What am I doing wrong?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Welcome to the board.

Change your lookup function to be:

=LOOKUP(J27,{"aincc","APCIMS Income Capital Return"; "ainct", "APCIMS Income Total Return"; ... "ftset","FTSE 100 Total Return"})
 
Upvote 0
From the Excel Help file:

Important The values in lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

Put the first array in sorted order.
 
Upvote 0

Forum statistics

Threads
1,223,165
Messages
6,170,461
Members
452,329
Latest member
Irefsports

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top