Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match data then comapre and return new data
I am try to find data on table1 and return data from table2. (discount
rate and Full rate) by enter data1 and data2 then enter formula to one off the cell to compare the price (data1+data2) and check in the Discount rate and if it is match then return the 596 (full rate) data1 data2 data1+data2 150 200 350 Discount rate Zone1 Zone2 Zone3 50 100 150 200 250 300 350 400 450 Full rate Zone1 Zone2 Zone3 85 170 255 340 425 510 595 680 765 Please help. Thank you in advance. Wong, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match data to another sheet and return all the data on that row | Excel Worksheet Functions | |||
Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
comapre two list of data & arranging in a same manner | New Users to Excel | |||
LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions |