V look up

Resolved · Low Priority · Version 2003

Fri 19 Sep 2008, 14:46 Delegate Jordana said...

Jordana has attended:
Excel Intermediate course

V look up

not sure how to do this - help please?

Thu 25 Sep 2008, 11:15 Trainer Greg said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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