Search a Row and return the column value

[Shockwiz_rentals_UK]

Hello

First post so here I go...

I have a customer who has a unique identifier (ACODE) and a list of serial numbers in separate columns.

I want to search for a serial number and then know which customer ACODE owns that serial number.

ACODE	Serial numbers	Serial numbers	Serial numbers
A123160	436175	436145	271432
A145906	699629	167777	698981
A145537	170820	170819	168556

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>

Thanks in advance

 

[steve the fish]

See if you can use this:

=INDEX($A$2:$A$4,AGGREGATE(15,6,(1/($B$2:$D$4=G1)*ROW($B$2:$D$4))-ROW($A$2)+1,1))

Table in A1:D4 and a serial number to search for in G1.

 

[Shockwiz_rentals_UK]

That worked! You are a genius!

Thank you so much