Can someone tell me why this function isnt working??

=VLOOKUP(C37:D37,A2:O34,MATCH(C38,Months,0)+2,FALS E)

C37:D37 = 2 different text strings
C38 = Dec04
Months = Dec04 through Dec05

I want it to find C37:D37 in A2:O34 and match it with the value in Value in
C38 which can be found in the defined name Months.

Hi
you can't use a range reference as first parameter of VLOOKUP this way.
Maybe you can try the following array formula (entered with
CTRL+SHIFT+ENTER):
=INDEX(A2:O34,MATCH(1,(C37=A2:A34)*(D37=B2:B34),0) ,MATCH(C38,Months,0)+2)

--
Regards
Frank Kabel
Frankfurt, Germany

Dominique Feteau wrote:
Can someone tell me why this function isnt working??

=VLOOKUP(C37:D37,A2:O34,MATCH(C38,Months,0)+2,FALS E)

C37:D37 = 2 different text strings
C38 = Dec04
Months = Dec04 through Dec05

I want it to find C37:D37 in A2:O34 and match it with the value in
Value in C38 which can be found in the defined name Months.

The first argument to VLOOKUP must be a single target string.

Can both strings be present, or only just one? If the former, do you want to
add the results from looking up each of the strings?

On Sat, 18 Dec 2004 12:16:59 -0600, "Dominique Feteau"
wrote:

Can someone tell me why this function isnt working??

=VLOOKUP(C37:D37,A2:O34,MATCH(C38,Months,0)+2,FAL SE)

C37:D37 = 2 different text strings
C38 = Dec04
Months = Dec04 through Dec05

I want it to find C37:D37 in A2:O34 and match it with the value in Value in
C38 which can be found in the defined name Months.

Frank...ur awesome.

worked like a charm. thanks a ton

niq

"Frank Kabel" wrote in message
...
Hi
you can't use a range reference as first parameter of VLOOKUP this way.
Maybe you can try the following array formula (entered with
CTRL+SHIFT+ENTER):
=INDEX(A2:O34,MATCH(1,(C37=A2:A34)*(D37=B2:B34),0) ,MATCH(C38,Months,0)+2)

--
Regards
Frank Kabel
Frankfurt, Germany

Dominique Feteau wrote:
Can someone tell me why this function isnt working??

=VLOOKUP(C37:D37,A2:O34,MATCH(C38,Months,0)+2,FALS E)

C37:D37 = 2 different text strings
C38 = Dec04
Months = Dec04 through Dec05

I want it to find C37:D37 in A2:O34 and match it with the value in
Value in C38 which can be found in the defined name Months.