Prev: Repeating rows not wanted
Next: Calculating Time?
From: dawnt13 on 6 Apr 2010 12:30

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.
--
Thank you
From: Bob Phillips on 6 Apr 2010 12:45
Try this array formula

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


--

HTH

Bob

"dawnt13" <dawnt13(a)discussions.microsoft.com> wrote in message
news:3EE2C3A9-FCB5-420A-A15C-F069F3CEED6E(a)microsoft.com...
>
> 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.
> --
> Thank you


From: Thanks on 6 Apr 2010 13:01
Can you post some sample data?

"dawnt13" wrote:

>
> 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.
> --
> Thank you
 | 
Pages: 1
Prev: Repeating rows not wanted
Next: Calculating Time?