Similar to the post at http://www.excelforum.com/excel-gene...x-columns.html, I want to pull data from a reference sheet. My problem is that the information is in a column to the left of the lookup data. I thought that the Offset function could pull data using a negative number from a row or column before the lookup data, but can only get a #N/A result. Attached is a sample file with my attempted formula: =VLOOKUP(B2,OFFSET(Reference!B:B,0,-1),1,FALSE)
Bookmarks