v h lookup

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

V + H Lookup

resolvedResolved · Medium Priority · Version 2003

Gemma has attended:
Excel Intermediate course
Excel Advanced course

V + H Lookup

How does the V Lookup + H Lookup functions work?

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:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips


Server loaded in 0.09 secs.