Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the difference between Vlookup and Hlookup ?

user-image
Question ajoutée par Tamer Mahmoud Bedir Ahmed , Senior Accountant , Cigalah Trading Group
Date de publication: 2013/12/30
Atif Tanveer
par 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