vlookup: search for value in SECOND column of table array and return value from FIRST

[matt_pl]

Hello
I'm looking for a formula to search for a value in the SECOND (instead of first) column of a table array and return a value in the same row from FIRST (instead of the same or another) column in the table array.

Formula would be searching for the unique production order number in the column B and return production line id from the column A.

A1 production line_id
B1 poduction_order_number

A2 L1
A3 L2
A4 L1

B2 505212
B3 504234
B4 505663

I was trying vlookup(504234;B2:A4;2;0) to make formula go search from right columns to the left but then excel is switching the search table to A2:B4 and gives #N/D!
One remark-there is no possibility to switch these 2 columns to simplify. I have to leave them as they are.
Can you help?
Matt

[sglife]

try this

=INDEX(A:A,MATCH(B2,B:B,0))

[matt_pl]

Works great. Thanks!

[mail2diptesh]

Worked great. Putting it here so people can view this solution without having to register.

INDEX(A:A,MATCH(B2,B:B,0))

thanks

[unamed1710]

Excellent work. Thanks

[maryamzk]

Thanks Thanks

Actually I was not a memeber of this forum, but when you published the answer for those who are not registered and cannot check the answer in the forum, I registered to thank you