How do I matchup this criteria?
I have two spreadsheets, one of which is a lever to which data is pulled, the
other is the source of the data. How do I get these guys to join up?
The sheet I'm pulling data to looks like this: (NDH means that I need data
to go there)
Date 1 Date 2 Date 3
Area (which changes) NDH NDH NDH
The sheet that I am getting data from looks like this?
Area 1 Area 2 Area 3
Date
Date
Date
Date
Basically, as the Areas and Dates change in the first worksheet, I need it
to pull the correct data by area and date from the second worksheet.
So,
A. How can I match it all up?
B. How can I do this so that if there is no data for a specific date, it
lists it as a 0?
Thanks,
CT
|