Yes. Open up both workbooks. Start to build your VLOOKUP as you would normally. When you want to select the lookup table range, navigate to the second workbook, the sheet, and the range. Press F4 to make the range absolute, if it isn't already. Put the comma in, type the column you want to return and, finally, type FALSE, close the bracket and press Enter.
Regards, TMS
Bookmarks