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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - VlookupvsHlookup
Resolved · Low Priority · Version Standard
Lebogang has attended:
Excel Advanced course
Hi
If I were to replace V with Hlookup do I need to change my table array? or will it still give me the same question.
CAn you refer me to websires were I can find complex workbooks to practice my formulas on?
Thanks,
Hlookup would look for value you have specified in the first ROW in your array. So depending on the result you are looking for, you may want to modify your range.
|
Excel tip:Add a € to your cellsIf you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4. |
We'll call during UK business hours
Server loaded in 0.07 secs.