Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Formulas
Hi Reva,
Thank you for your question.
The Vlookup function is used to retrieve data from an xcel list where the data is arranged in columns.
The Hlookup function is used to retrieve data from an Excel list where the data is arranged in rows.
Regards
Simon
Did you know the shortcut key for applying and removing the outline border for a cell?
CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 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.
