• 0

Excel Help


Question

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

  • 0
No problem :) Don't forget if / iserror if you want to replace the no match found error from #N/A =IF(ISERROR(VLOOKUP( ...

In Excel 2007 onwards you can use "=IFERROR(..." instead.

This will calculate faster when using large arrays in formulas (e.g. VLOOKUP)

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.