excel

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 » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Nidaa has attended:
Excel Intermediate course

Excel

What's the difference between V look up and H look up?

RE: Excel

Hello Nidaa

Thank you for your question and welcome to the forum.

The VLOOKUP function is used when your data is arranged down columns, i.e. you have headings running across a row, with related data stored down the columns underneath.

The HLOOKUP function is used with your data is arranged across rows, i.e. you have headings running down a column, with related data stored across the rows beside the headings.

I hope this helps.
Amanda


 

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Server loaded in 0.08 secs.