Lookup, Match, Return

[djc123]

Hey gang,

I would like to be able to find and match a value in 23 collumns, and then return the value in another column.

On the sheet attached - columns A through W are a list of product codes. I would like the value listed in column AE (green), to be matched with any value in the large red area (A2:W806), and to return the COST, in column AA.

Thank you so much.

Danny

[Bo_Ry]

Please try at AF2

=INDEX(AA:AA,MAX(INDEX(ROW($A$2:$W$806)*($A$2:$W$806=AE2),)))

[CARACALLA]

AF2=IF($AE2<>"",SUMPRODUCT(($A$2:$W$806=$AE2)*($AA$2:$AA$806)),"")

Copy down

[djc123]

Thank you so much guys! It worked a treat!