How to change a cell to reflect an amount in another cell with numerous possible values

[texas_pete]

Hello,

This is my first post so apologies if it's not in the correct thread. I'm fairly new to excel.

I'm looking for a specific formula (not a calculation).

I have specific prices for items in my shop which have discounted RRP prices. There is no calculation to work out the discount I want to offer on each RRP but I already have set prices for each RRP. Here's an example;

RRP Selling Price
$24.99 $18.50
$30.00 $23.84
$75.00 $59.97

My selling prices never change (and they are just set prices so there's no formula to work them out) but I have large volumes of stock so it's a pain manually changing each selling price to reflect the RRP.

I want a formula which says something along the lines of 'if a1 =$24.99 then b1=$18.50 or if a1=$30.00 then b1=$23.84 and so on'. I realise this would be a long formula as there are about 50 different RRPs but think this is the only way I could do it.

Can anyone please help me with this?

[JohnTopley]

Removed as reqested

[ChemistB]

Set up your table of RRP and Selling prices on Sheet2 in Column A and B so, assuming there's a header, lets say in sheet2!A2:B52

Then on Sheet1, if your RRP is in A3, in B3 use this formula

=VLOOKUP(A3, Sheet2!$A$2:$B$52, 2, FALSE)

If you are going to have a whole column of RRP in column A, you might want this formula in B3 copied down

=IF(ISNUMBER(A3), VLOOKUP(A3, Sheet2!$A$2:$B$52, 2, FALSE), "")

Here is a good link to learn more about VLOOKUP
http://www.contextures.com/xlFunctions02.html

[Tony Valko]

Sounds like you want this...

http://contextures.com/xlFunctions02.html