98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » training excel vba - V Look Ups
training excel vba - V Look Ups
Resolved · Low Priority · Version Standard
Natascha has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
V Look Ups
WHich is the best course to attned to learn about V Look ups ?
RE: V Look Ups
There are many resources on the web for vlookup
simply though, a vlookup searches in a named range and returns the value in the specified column of the range
Say you have a list of people in sheet2, column A is the person's user number. Column B is their first name, column C is their surname and column D is their favourite colour.
1 James King Brown
2 Peter Smith Pink
3 Ryan Jones Yellow
4 Jill McLeish Green
5 Laura Chivers Red
lets say you want to type in the persons user number and get excel to return their favourite colour in the cell next to it.
in sheet1 Cell A2 type '=vlookup(A1,Sheet2!A:D,4,0)' (without the speech marks of course) and press enter
now, when you type a number into cell A1 on sheet 1 and press enter, cell A2 on sheet 1 will change to the favourite colour of that person
the vlookup formula is explained like this:
=vlookup(cell with the related data, range to look in, the number column you want to return data from,look for exact matches only)
hope this helps.
Paul
RE: V Look Ups
Dear Natacha
The best course to be on for VLookUP is Excel Advanced!! You can book for 2002, 2003 or even 2007 if you want!!
Please go to the following link to see when is the next Excel Intermediate course is scheduled:
https://www.stl-training.co.uk/order/pricing_availability.php
just copy and paste this in whichever browser you use i.e. Internet explorer, Mozilla FireFox, Netscape Navigator, etc....)
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:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |