Need to bring back 2 vlookup values

D

dawnt13

1 Week Ending Mar 28, 2010 TOTAL US - GROC 100
__________________________________________
I need to return back the number 100 when I have two vlookup functions that
differ - e.g. first vlookup value would have be '1 Week Ending Mar 28, 2010'
and the second vlookup value would be 'TOTAL US - GROC' once those are both
found, the number 100 would come back. How do you do two vlookups to get one
number back? I have been using sumproduct but it takes a long time to get my
data back.
 
B

Bob Phillips

Try this array formula

=INDEX(C2:C200,MATCH(1,(B2;B200="1 Week Ending Mar 28,
2010")*(B2:B200="TOTAL US - GROC"),0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Multiple VLOOKUP lookup values 1
Removing ''VALUES'' 5
HLOOKUP & VLOOKUP Combinded 4
Finding the proper style field and the numbered paragraph value within the style 0
lookup to bring back multiple values 3
Finding the right style field in VBA 0
Use vlookup to bring back data from second occurrence of the value 1

Top