Andrea Bernard
asked on
Need help on excel formula
Last question I'll ever ask! Someone helped me with this formula a few days ago and when I moved it into my working file it's not working... I need to use the Class Number and Current Retail in the worksheet tab and look to the Data tab and return the corresponding price tier that the it would fall into...
Excel-help-3.xlsm
Excel-help-3.xlsm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the confusion, I must have only copied over a certain section of data. Please see attached where price would come into effect, because the Class numbers have multiple price tiers.
Thank you!
Andrea
EE-29067113-Excel-help-3-Version1.xlsm