Excel 2007 : IFERROR(LOOKUP, how to return the first value in a row

[Martin Chamberlin]

My formula works [=IFERROR(LOOKUP(2,1/(A3:AK3=A8),A2:AK2),"")]

However, the value it returns is the last one in the row. (There could be multiple repeats in A3:AK3). e.g. if A8 appears in cells B3 and M3, it returns a date from M2.

I need it to return the first value it sees, in this case it would be B2.

Help appreciated. Have tried an hlookup also but cant get that to work either.

Chambo



Many many thanks for the help

[daddylonglegs]

Try this version

=IFERROR(INDEX(A2:AK2,MATCH(A8,A3:AK3,0)),"")

[Martin Chamberlin]

Try this version

=IFERROR(INDEX(A2:AK2,MATCH(A8,A3:AK3,0)),"")

You rock man. Sorted with much gratitude,

Chambo (Martin)