VLOOKUP - Separate Workbook

[mlbdc2012]

Does anyone know the formula to VLOOKUP data from a completely separate workbook?

[TMS]

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

[mlbdc2012]

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

Awesome thanks!

[TMS]

You're welcome. Thanks for the rep.

[mlbdc2012]

Does this work with excel online as well?

[TMS]

Dunno. Not something I am familiar with.

Maybe ask the question in a new thread.