98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » V-lookup
V-lookup
Resolved · Low Priority · Version 2003
Fri 3 Apr 2009, 16:30Delegate Daniela said...
Daniela has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
V-lookup
v-lookup and if function
Mon 6 Apr 2009, 13:01Trainer Amanda said...
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
Wed 15 Apr 2009, 16:41Trainer Rajeev said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |
