Need to bring back 2 vlookup values

  • Thread starter Thread starter dawnt13
  • Start date Start date
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.
 
Try this array formula

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