The instructions for vlookup say the lookup value must be in the first column
of the lookup array. Unfortunately I want to look up values in a spreadsheet
with a standard format which I can't change, and the lookup value is in
column B and the value I want to return is in column A. Is there a clever
trick of getting vlookup to do this (other than simply making a personal copy
of the spreadsheet with the columns reversed)?

Grateful for ideas.