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 » Excel Vlookup
Excel Vlookup
Resolved · Low Priority · Version 2003
Wed 19 Nov 2008, 16:27Delegate Steve said...
Steve has attended:
Project Management - Framework & Processes course
Excel Advanced course
Excel Vlookup
Can I have some extra vlookup practice please?
Mon 24 Nov 2008, 12:44Trainer Simon said...
RE: Excel Vlookup
Hi Steve,
Thank you for your question.
Here is an example of a spreadsheet you can build to practice Vlookup formulas. Type the data below in sheet 1:
Country Capital Population
UK London 7,512,400
SPAIN Madrid 5,078,000
ITALY Rome 4,000,000
The data above is your excel list (table array).
On a second sheet type the following in different cells:
Country (label in Cell A1) - The cell you type the country you are searching for will be Cell B1 (Lookup value in the formula).
Capital (label in Cell A3) - Vlookup formula in cell B3
Population (label in A4) - Vlookup formula in cell B4
I hope this helps you.
Regards
Simon
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:Entering text in Multiple WorksheetsIf you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows: |
