One of the VLOOKUP function’s key limitations is that it can only lookup values to the right. In other words, the column that contains lookup values must sit the the left of the values you want to retrieve with VLOOKUP.
Generic formula
=VLOOKUP(A1,CHOOSE({1,2},range2,range1),2,0)