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