excel.advanced.course - v lookup

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

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

excel.advanced.course - V lookup

resolvedResolved · Low Priority · Version 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


 

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Server loaded in 0.09 secs.