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

vlookup

ResolvedVersion 2003

mandy has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course

Vlookup

what heading is vlookup under?

RE: vlookup

Hi Mandy,

Thank you for your question.

If you go to INSERT - FUNCTION and then select the LOOKUP & REFERENCE category, you will find the function right at the end of the list.

I hope this answers your question.

Regards

Simon

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

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.09 secs.