Forum home » Delegate support and help forum » Microsoft Excel Training and help » How does VLOOKUP work?
|
|
|
The UK's most regular 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. |
How does VLOOKUP work?
Resolved · High Priority · Version 2010
Reply Fri 25 Nov 2011, 12:54Delegate Evanthia said...
Evanthia has attended:
Excel Intermediate course
VLOOKUP
How exactly does this work? I need this function in my everyday work so I would love some advice please.
For upcoming training course dates see: Pricing & availability
RE: VLOOKUP
Hi Evanthia,
Thank you for your feedback and welcome to the forum.
The Vlookup formula has four arguments:
(Lookup_Value,Table_array,Column_Index_Number,Range_Lookup)
The function is used to search for a value entered into a cell, search for that value in the first column of your database(Table_Array) and return the value from a column you specify in the same row.
Please find the link below:
http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel
This is a working example. I have also attached an example spreadsheet with an example.
I hope this helps you.
Regards
Simon
Attached files...
Vlookup example and notes.xlsxThu 1 Dec 2011: Automatically marked as resolved.
|