index match 1 row 2 columns, date ranges included

[distribution master]

i need to fill in the information for "Green", "Red", and "Blue" with the rows' information of "Dates", and "Pricing Class" in sheet "Data" with the information from sheet "Pricing".

[bebo021999]

In C2, Green:

Please Login or Register  to view this content.

Copy down and across

[distribution master]

it's all zeros

i uploaded it again and changed added some stuff

[distribution master]

hold on, wrong file, this one should do it

[bebo021999]

What is your designed result? Can you give some?

[distribution master]

i want "green" "red" and "blue" to choose only from the "pricing class" entries that match, then do an index match based on what's left and I want it to be "1 - Less than" for "date"

[bebo021999]

This may do that:

Please Login or Register  to view this content.

[distribution master]

it only worked for some cells

some have results, some are blank

i uploaded the results

[bebo021999]

Sheet Data, row 2, date 2012-1-18, class 1 have no active price in Pricing sheet. Same to other blank results.
Row 5, date 2012-02-19, class 2 have active price in pricing sheet, row 3, where the date is 2012-02-18, class 2.
Is it clear?

[distribution master]

ok, i understand, i don't have any data for it to compute. i have the concept though, thx a lot