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

Removing ''VALUES'' 5
Sum the results of a vlookup 6
Use vlookup to bring back data from second occurrence of the value 1
lookup to bring back multiple values 3
vlookup 2 fields 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Lookup Values 4
VLOOKUP and IF Functions 2

Top