excel advanced training - lookup
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced training - Lookup

excel advanced training - Lookup

resolvedResolved · Low Priority · Version Standard

replyReply Wed 17 Oct 2007, 15:22Delegate Valani said...

Valani has attended:
Excel Advanced course
Excel Advanced course

Lookup

How do I use lookup

For upcoming training course dates see: Pricing & availability

replyReply Wed 17 Oct 2007, 16:42Trainer Amanda said...

RE: Lookup

Hi Valani

Thank you for your question.

The VLOOKUP function is used to get Excel to find a specific value (the lookup value) in one column, and display a corresponding value in the same row as the lookup value.

The HLOOKUP function works the same way, but for information that is stored in rows instead of columns.

Amanda

 

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard