vlookup and hlookup

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup and Hlookup

Vlookup and Hlookup

resolvedResolved · Low Priority · Version 2003

Barnaby has attended:
Excel Intermediate course

Vlookup and Hlookup

What is the purpose behind Vlookup and Hlookup

RE: Vlookup and Hlookup

Hi Barnaby

Thank you for your question and welcome to the forum.

VLOOKUP and HLOOKUP functions are designed to get Excel to extract a certain piece of information from a list/database in Excel.

Basically VLOOKUP is used to get Excel to search for something in the left most column of a table, then find a corresponding piece of data from the same row and display it for you.

HLOOKUP is used to get Excel to search for something in the top row of a table, then find a corresponding piece of data from the same column and display it for you.

I hope this helps.
Amanda


 

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Server loaded in 0.09 secs.