excel.advanced.course - vlookups

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 - Vlookups

excel.advanced.course - Vlookups

resolvedResolved · Low Priority · Version Standard

Sean has attended:
Excel Intermediate course

Vlookups

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

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

Attached files...

VLookup example.xls


 

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips


Server loaded in 0.1 secs.