How do I matchup this criteria?

[Guest]

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

 

[Guest]

http://office.microsoft.com/en-us/assistance/HA011549021033.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!A21000, Match(A2, DataSheet!B11, 0), False)

to get 0 instead of error

=if(iserror
(Vlookup(B1, DataSheet!A21000, Match(A2, DataSheet!B11, 0), False),
0 ,
Vlookup(B1, DataSheet!A21000, Match(A2, DataSheet!B11, 0), False))