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

vlookup

ResolvedVersion 2003

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

V-lookup

v-lookup and if function

RE: v-lookup

Hello Daniela

Thank you for your question.

Is there something specific that you would like to know about these functions? If you can clarify further then I can make my reply more relevant.

Kind regards
Amanda

RE: v-lookup

Dear Daniela

I have answered how does VLookup works in one of my previous posts so please refer to the following links to see if it helps you. Please note that there is an Excel file for your reference at the end of that post:

https://www.stl-training.co.uk/post-9632-vlookups.html

Please find the below link for If Statement:

https://www.stl-training.co.uk/post-12732-formulas.html

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Wed 22 Apr 2009: Automatically marked as resolved.

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

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.