A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple VLOOKUP



 
 
Thread Tools Display Modes
  #1  
Old January 17th, 2005, 10:31 AM
Rody
external usenet poster
 
Posts: n/a
Default Multiple VLOOKUP

How do I get to run a multiple VLOOKUP?

Thanks

  #2  
Old January 17th, 2005, 10:35 AM
cmart02
external usenet poster
 
Posts: n/a
Default

I'm not sure if this is what you want, but... YOu can try:

=IF(ISERR(INDEX(B1:B8,SMALL(IF(A1:A8=C2,ROW(A1:A8) ,""),ROW(A1:A8)))),"",INDEX(B1:B8,SMALL(IF(A1:A8=C 2,ROW(A1:A8),""),ROW(A1:A8))))}

Press CTRL+SHIFT+ENTER after all that...

Regards,
Robert


"Rody" wrote:

How do I get to run a multiple VLOOKUP?

Thanks

  #3  
Old January 17th, 2005, 12:05 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

If by chance you mean a double lookup, where you have 2 key columns and you
want to match both and get the adjacent value in another column, you can use

=INDEX(C1:C100, MATCH(D1&D2,A1:A100&B1:B100,0))

which is also an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cmart02" wrote in message
...
I'm not sure if this is what you want, but... YOu can try:


=IF(ISERR(INDEX(B1:B8,SMALL(IF(A1:A8=C2,ROW(A1:A8) ,""),ROW(A1:A8)))),"",INDE
X(B1:B8,SMALL(IF(A1:A8=C2,ROW(A1:A8),""),ROW(A1:A8 ))))}

Press CTRL+SHIFT+ENTER after all that...

Regards,
Robert


"Rody" wrote:

How do I get to run a multiple VLOOKUP?

Thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP on multiple columns JTR Worksheet Functions 2 August 12th, 2004 06:37 PM
Multiple Many-To-Many Tables Tom Database Design 7 May 15th, 2004 03:47 AM
Vlookup across multiple sheets Brian Worksheet Functions 6 March 11th, 2004 12:05 AM
Vlookup - Multiple columns - How do I do this in Excel? SteveJ Worksheet Functions 1 October 23rd, 2003 02:57 PM


All times are GMT +1. The time now is 08:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.