excel.advanced.course - Vlookups

Resolved · Low Priority · Version Standard

Mon 21 Jan 2008, 17:06 Delegate Sean said...

Sean has attended:
Excel Intermediate course

Vlookups

Not too sure about how to set up a vlookup. May need further advice/help.

Sat 26 Jan 2008, 18:23 Trainer Rajeev said...

RE: vlookups

Dear Sean

Thank you for attending the Excel Intermediate course.

VLookup is basically a function that can help you to retrieve data from a table that may have lots of information. Please note that if you can only use Vlookup if the column headings in the table are arranged vertically. Normally people have the data arranged in this format.

If the main headings are arranged in rows then you have you use the HLookup.

Please refer to the file that I have uploaded for the below mentioned explanation:

If you notice Cell Range A9:F49 is the main table.
A6 is the cell which other cells on the right will refer to display the result. Therefore, this will be our Lookup value.

In Cell B6 I entered the following formula:

=VLOOKUP(A6,A9:F49,2,FALSE)

Let