W
wsukmaha
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,
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,