Trying to compare current pricing and costs with suggested pricing

**dearnne** · 11-28-2013, 06:02 PM

Hi there, I'm new to this forum and am after some help. I have an item which is currently being charged on rate 1. I want to create a lookup/comparison table where it shows what the item would cost if charged on rate 2. I have all my variables stored in an excel spreadsheet. What would be the best way to complete this without performing over 100 if/then/else commands?

**FDibbins** · 11-28-2013, 06:30 PM

Hi and welcome to the forum

I suggest, if you have your data in a table format, use vlookup() to find your answer.

If you dont have the data in a table, put it a table, andthe refer to the line above

**dearnne** · 11-28-2013, 06:37 PM

Thanks, I was just thinking that as you replied. I was agonising over this all afternoon yesterday trying to think of a good way to do it and of course - vlookup is the best way! I don't know why it didn't come to me earlier!!!

**FDibbins** · 11-28-2013, 07:01 PM

Always keep the KISS principal in mind

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)