View Single Post
  #1   Report Post  
Chase
 
Posts: n/a
Default 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