Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · Low Priority · Version 2003
Nidaa has attended:
Excel Intermediate course
What's the difference between V look up and H look up?
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 dataTo 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. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
