T
Tony
I have a worksheet pulls values from a source worksheet ('Jurisdiction
Entries'!$C$2:$C$35) based on a date I fill in on the target worksheet (A5)
and a state code (B3..). It brings in a couple of fields when it matches the
date ('Jurisdiction Entries'!$A$2:$A$35,0) and state code
(Entries'!$B$2:$B$35,0) in the source worksheet. When I cuse 09/30/2002 as my
date, it works fine. When I change to another date such as 09/30/2008, I get
a reference error (#REF!).
Here is the formula:
=INDEX('Jurisdiction Entries'!$C$2:$C$35,MATCH($A5,'Jurisdiction
Entries'!$B$2:$B$35,0),MATCH($B$3,'Jurisdiction Entries'!$A$2:$A$35,0))
Target Document
PERIOD ENDING: Tuesday, September 30, 2008 MATCH (A5)
(B3)
CT #REF! #REF! 0.0000%
Source Document
(A2:A35) (B2:B35) (C2:C35)
09/30/2002 WI 100
09/30/2002 WV 200
09/30/2008 CT 300
09/30/2008 IL 400
Could someone tell what I have to to be able to just change the date and
pick up the associated data.
Thanks
Tony D.
Entries'!$C$2:$C$35) based on a date I fill in on the target worksheet (A5)
and a state code (B3..). It brings in a couple of fields when it matches the
date ('Jurisdiction Entries'!$A$2:$A$35,0) and state code
(Entries'!$B$2:$B$35,0) in the source worksheet. When I cuse 09/30/2002 as my
date, it works fine. When I change to another date such as 09/30/2008, I get
a reference error (#REF!).
Here is the formula:
=INDEX('Jurisdiction Entries'!$C$2:$C$35,MATCH($A5,'Jurisdiction
Entries'!$B$2:$B$35,0),MATCH($B$3,'Jurisdiction Entries'!$A$2:$A$35,0))
Target Document
PERIOD ENDING: Tuesday, September 30, 2008 MATCH (A5)
(B3)
CT #REF! #REF! 0.0000%
Source Document
(A2:A35) (B2:B35) (C2:C35)
09/30/2002 WI 100
09/30/2002 WV 200
09/30/2008 CT 300
09/30/2008 IL 400
Could someone tell what I have to to be able to just change the date and
pick up the associated data.
Thanks
Tony D.