excel.advanced.course - V lookup

Hi Hanif

Thank you for your question.

You can create a vlookup formula in one workbook which looks up information from a table in a different workbook.

You need to have both workbooks open when you create the vlookup formula. Also you need to be careful with renaming or moving the file that contains the table, as this will then need to be linked back up to the workbook containing the vlookup formula.

I hope this helps.
Amanda