Auto substract by comparing the category

E

expert40

I am having two sheets .Sheet one contains the following data

category Total amount Remaining
category1 1000
category2 2500
category3 600
category4 9000

Sheet2 having

Name category Final
suresh category1 500
ravi category2
rajesh category3
ramesh category4

If i enter 500 in final for category1 then ,my formula should do

Search for the category in sheet1 so now category is category1 so ,
have to populate

totalamount-final=500 in remaining of category column1 in sheet1.
please try to help
 

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