excel advanced training - lookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Valani has attended:
Excel Advanced course
Excel Advanced course

Lookup

How do I use lookup

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:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.08 secs.