microsoft+excel+training+course - v 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 » microsoft+excel+training+course - V lookup

microsoft+excel+training+course - V lookup

resolvedResolved · Low Priority · Version Standard

Tamara has attended:
Excel Intermediate course
Excel Introduction course
Excel Advanced course

V lookup

how do i do this?

RE: v lookup

vlookup looks for a certain bit of data in a range of cells and returns a column in that range

if you have a list of customer numbers and you want excel to look for the customer's surname, you can do something like this in cell B2:

=vlookup(A2,Sheet2!A:C,3,0)

looks for whatever is in cell A2 in the range of column A to column C on sheet 2 and returns the 3rd column in the range (column C)


 

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.08 secs.