v look up
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

V look up

resolvedResolved · Low Priority · Version 2003

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

Jordana has attended:
Excel Intermediate course

V look up

not sure how to do this - help please?

For upcoming training course dates see: Pricing & availability

replyReply Thu 25 Sep 2008, 11:15Trainer 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

 

Please browse our web site to find out more about
training courses in excel and other Microsoft training courses.

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard