V look ups

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

V look ups

Nolan has attended:
Excel Intermediate course

by - delegate Nolan [1 post] (2008 Feb 21 Thu, 16:50) Reply

help

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: v look ups

by - trainer Rich platinum contributer [754 posts] (2008 Feb 23 Sat, 21:58) Reply

If you have two sets of data, highlight the second set and in the top left corner of the screen is the name box, in this box type 'Range1' and press the Enter key. Create a new column in your first set of data. In the first cell use the following formula:

=VLOOKUP(B1,Range1,1,FALSE)

This is essentially saying "take the value in B1 (B is the ID column of your first data set), and see if it occurs anywhere in Range1 (Range1 is the ID column of your second data set). If it does appear then it will return the ID (column 1, hence the 1 in the formula) and if it doesn't appear then it will return '#N/A'. The value of 1 will make it return the ID value. You can return any column in the range. For example, if you have column1 as the ID and column2 as the full name then you can change the formula as follows to return the second colum and therefore show the name:

=VLOOKUP(B1,Range1,2,FALSE)

Please see attached example

Attached files...

Example.xls

Training by application

Main information pages

V look ups

Attached files...

Related articles

Excel tip:

Creating Quick Column Charts