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 |
#2
|
|||
|
|||
How do I matchup this criteria?
http://office.microsoft.com/en-us/as...549021033.aspx
combine Vlookup and match assume Date 1 in B1, variableArea in A2 name on data sheet tab is "DataSheet" NDH cell formula in B2 =Vlookup(B1, DataSheet!A2:D1000, Match(A2, DataSheet!B1:D1, 0), False) to get 0 instead of error =if(iserror (Vlookup(B1, DataSheet!A2:D1000, Match(A2, DataSheet!B1:D1, 0), False), 0 , Vlookup(B1, DataSheet!A2:D1000, Match(A2, DataSheet!B1:D1, 0), False)) "Chase" wrote: 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 |
Reply |
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 |