Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between Vlookup and Hlookup ?

user-image
Question added by Tamer Mahmoud Bedir Ahmed , Senior Accountant , Cigalah Trading Group
Date Posted: 2013/12/30
Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

VLookup searches down the leftmost column of a table for a match and returns a value from a column to the right of the match on the same row.

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm HLookup searches left to right across a row of entries for a match and returns a value from a row below the column the match was found in.

http://spreadsheets.about.com/od/excelslookupfunctions/ss/-excel-2007-hlookup-tutorial-sbs.htm

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.