# Lookup

#### jl21

##### New Member
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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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"})

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.

Replies
0
Views
303
Replies
1
Views
2K
Replies
10
Views
604
Replies
38
Views
5K
Replies
7
Views
1K

1,196,151
Messages
6,013,738
Members
441,781
Latest member
Gian Carlos

### 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.

### Which adblocker are you using?

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

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