I'm trying to create an automatic pricing sheet for work. There isn't a specific % of the cost that is charged for maintenance so I have to put all the data in a different sheet and reference too it.
So what I have in the reference sheet is the number of users and then a price to be charged. I need to make a formula in another sheet that looks at this sheet.
in a1 we would enter a number
b1 would be =IF(A1=Sheet1!A1,Sheet1!B1,if(A1=Sheet1!A2,Sheet1!B2,if(A1=Sheet1!A3,Sheet1!B3,.....)
Is there a better way to do this so that I don't need to type out each of the 250 reference lines?
Question
HouseCookie
Hey all,
I'm trying to create an automatic pricing sheet for work. There isn't a specific % of the cost that is charged for maintenance so I have to put all the data in a different sheet and reference too it.
So what I have in the reference sheet is the number of users and then a price to be charged. I need to make a formula in another sheet that looks at this sheet.
in a1 we would enter a number
b1 would be =IF(A1=Sheet1!A1,Sheet1!B1,if(A1=Sheet1!A2,Sheet1!B2,if(A1=Sheet1!A3,Sheet1!B3,.....)
Is there a better way to do this so that I don't need to type out each of the 250 reference lines?
Link to comment
Share on other sites
4 answers to this question
Recommended Posts