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.