Match data then comapre and return new data

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top