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?
=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?