Multiple VLOOKUP

The UK's most regular instructor-led training courses.
Training information: training courses in excel · Excel in courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Multiple VLOOKUP

Mariagiulia has attended:
Excel Advanced course
Excel VBA course
Excel VBA Advanced course

by - delegate Mariagiulia [4 posts] (2008 Feb 7 Thu, 11:20) Reply

How can I use more than one VLookup in the same fomula please? Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Multiple VLOOKUP

by - delegate Paul gold contributer [121 posts] (2008 Feb 7 Thu, 12:32) Reply

Hi,

It'd be quite difficult if at all possible and I don't think it's really needed.

What is the situation you have? I'm sure it can be solved an easier way.

Paul

RE: Multiple VLOOKUP

by - delegate Mariagiulia [4 posts] (2008 Feb 8 Fri, 09:16) Reply

If you can have a look at my spreadsheet, I can send it to you on Monday (I in a course today) and I will explain what I need to do. thanks

· Database Tips from an Excel Training Course
· Identifying Suitable Candidates For VBA For Excel Training
· Tap the Power of Recorded Macros with MS Excel Courses
· Compare Different MS Excel Training Methods
· Microsoft Excel Training Course

Please browse our web site to find out more about
training courses in excel and other Microsoft training courses.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips

Rate this page: