LinkBack URL
About LinkBacks
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".
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".
In C2, Green:
Copy down and across
Please Login or Register to view this content.
Quang PT
it's all zeros
i uploaded it again and changed added some stuff
hold on, wrong file, this one should do it
What is your designed result? Can you give some?
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"
This may do that:
Please Login or Register to view this content.
it only worked for some cells
some have results, some are blank
i uploaded the results
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?
ok, i understand, i don't have any data for it to compute. i have the concept though, thx a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks