Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |