Vlookup from another sheet where data is not in left to right order
I am trying to pull data into a Smartsheet from another VERY large Smartsheet. The data I am looking up is to the right of the data I want to populate via a VLOOKUP, which is why I believe my formula isn't working.
On my new sheet, my search value is located in column 3, which would be the Purchase Order Numbers.
From the VERY large sheet, the lookup table range has the search value (the PO Numbers) in column 5 and the value I need to return (the Sales Order Number) is in column 2.
I know the criteria for a VLOOKUP is that the "lookup table" needs to have search value in the leftmost column, but unfortunately, I don't have that option in this situation. Is there any working around this?
Thanks in advance for the assistance.