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

excel.advanced.course - vlookups

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Vlookups

excel.advanced.course - Vlookups

ResolvedVersion 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:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.56 secs.