Vlookup Problem

[Dominique Feteau]

Can someone tell me why this function isnt working??

=VLOOKUP(C3737,A2:O34,MATCH(C38,Months,0)+2,FALSE)

C3737 = 2 different text strings
C38 = Dec04
Months = Dec04 through Dec05

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

 

[Frank Kabel]

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)

 

[Myrna Larson]

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?

 

[Dominique Feteau]

Frank...ur awesome.

worked like a charm. thanks a ton

niq