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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » V + H Lookup

V + H Lookup

ResolvedVersion 2003

Mon 3 Nov 2008, 16:32 Delegate Gemma said...

Gemma has attended:
Excel Intermediate course
Excel Advanced course

V + H Lookup

How does the V Lookup + H Lookup functions work?

Tue 4 Nov 2008, 17:12 Trainer Amanda said...

RE: V + H Lookup

Hello Gemma

Thank you for your question and welcome to the forum.

The V and HLOOKUP functions allow you to get Excel to find a specific piece of information in the left most column (for VLOOKUP) or top row of a table (for HLOOKUP), and then extract a corresponding value from another column (VLOOKUP) or row (HLOOKUP) in the table.

We cover these functions as part of our Excel Advanced training course.

Kind regards
Amanda

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

V + H Lookup

V + H Lookup

RE: V + H Lookup

Excel articles

Excel tip:

COUNT function vs COUNTA function