v look up

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » V look up

V look up

resolvedResolved · Low Priority · Version 2003

Jordana has attended:
Excel Intermediate course

V look up

not sure how to do this - help please?

RE: v look up

Hello Jordana,

My name is Greg Eze and I am one of the trainers at Best.
Vloojup searches for the value in the first column of a table and returns a value in the second table.

In term of Vlookup, I can give you an example of how it works if it is any good to you.

1. Copy this table - from range A1: B4 :
salesperson


 

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Server loaded in 0.1 secs.