How to use the MATCH function in Google Sheets - Sheetgo Blog
The function I used to do this is =INDEX (A2:A11,MATCH (161,C2:C11,0)). As you can see, unlike VLOOKUP, the combination works even if the lookup column is not the leftmost (see the first three examples in the above screenshot). Not surprisingly, it also works like VLOOKUP, when the lookup column is the leftmost.
DA: 14 PA: 10 MOZ Rank: 88