Lookup

[jl21]

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?

 

[Oaktree]

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"})

 

[Seti]

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.