We are tired of that we have to manually look up in our excel table to be able to give our customers a price quote and we would like to make life a little simpler for ourselves. We would like to enter 4 values in the excel sheet and based on those values excel should look up prices in two different tables.
I have attached a excel file. In sheet 1 we would like to enter a value for “value 1” and excel should look up price for that value based on attribute1 and attribute2 in table 1. We also enter a value for “value 2” and excel should then go into table 2 and look up price also based on attribute1 and attribute2. The estimated price should be the lowest of price from table 1 and from table 2. Our customers also have the ability to buy some additional which have to be added to the price. See excel sheet for clarifications.
39 freelancers are bidding on average $70 for this job
I am interested in this job. I am very familiar with Excel and is very capable of doing this job. I am also using Excel in the business. Hope to hear from you soon.
I have an complete knowledge in Excel. I can complete this work within 30days and I dont need any initial amount after complete this work then only i expect money from your.