Thread: Vlookup Problem
View Single Post
  #1   Report Post  
Dominique Feteau
 
Posts: n/a
Default Vlookup Problem

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.