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

advanced.excel - v lookup

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

advanced.excel - V Lookup

ResolvedVersion Standard

Jayson has attended:
Excel Introduction course

V Lookup

how to use V Lookup

RE: V Lookup

Hi Jayson,

Thanks for the question.

A VLookup searches for a certain word or item within a long list and returns the value in the associated column.

So, for example, =Vlookup(A1, B2:D5, 3) looks for the value in A1 within the list in the range B2:D5 and returns the contents of the cell in the third column along.

Hope that helps, if there is anything specific let me know

Tracy

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.