Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel.advanced.course - v lookup

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - V lookup

excel.advanced.course - V lookup

ResolvedVersion Standard

Hanif has attended:
Excel Advanced course

V lookup

How do you v lookup across diffrent excel work books?

RE: 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.