two lookups

[Johnboy28]

Hi,

Can someone help with a formula - If an amended price is present it will calculate product weight value with new price, if not it will use current pricing. Thanks for your help.

New Pricing	Current Pricing
Amended Code	Amended Price	Product Weight	Actual Code	Price/kg	Actual Value	Amended Value
		150	16732	$1.38	$6,999.06	$206.32
		250	16902	$7.59	$17,742.82	$1,896.36
		350	16953	$2.89	$4,090.01	$1,009.91
15506	$7.89	650	16973	$3.20	$4,576.08	??
26354	$8.10	500	20104	$7.79	$16,115.59	??
		450	20112	$4.00	$652.06	1797.9525
		250	20147	$6.87	$18,813.97	1716.2525
15506	$7.89	360	20409	$6.64	$289.68	??
					$69,279.28	$6,626.79

<tbody>
</tbody>

 

[Cross Terrier]

Don't you need a volume in there somewhere?

 

[FormR]

If an amended price is present it will calculate product weight value with new price, if not it will use current pricing

Hi, like this maybe:

Excel 2013/2016
	A	B	C	D	E	F	G
2	Amended Code	Amended Price	Product Weight	Actual Code	Price/kg	Actual Value	Amended Value
3			150	16732	1.38	6,999.06	207
4			250	16902	7.59	17,742.82	1897.5
5			350	16953	2.89	4,090.01	1011.5
6	15506	7.89	650	16973	3.2	4,576.08	5128.5
7	26354	8.1	500	20104	7.79	16,115.59	4050
8			450	20112	4	652.06	1800
9			250	20147	6.87	18,813.97	1717.5
10	15506	7.89	360	20409	6.64	289.68	2840.4
Sheet1

Cell Formulas
Range	Formula
G3	=C3*IF(ISNUMBER(B3),B3,E3)

 

[wideboydixon]

Just this?

Book1
	A	B	C	D	E	F	G
1	New Pricing		Current Pricing
2	Amended Code	Amended Price	Product Weight	Actual Code	Price/kg	Actual Value	Amended Value
3			150	16732	£1.38	£6,999.06	£206.32
4			250	16902	£7.59	£17,742.82	£1,896.36
5			350	16953	£2.89	£4,090.01	£1,009.91
6	15506	£7.89	650	16973	£3.20	£4,576.08	£5,128.50
7	26354	£8.10	500	20104	£7.79	£16,115.59	£4,050.00
8			450	20112	£4.00	£652.06	£1,797.95
9			250	20147	£6.87	£18,813.97	£1,716.25
10	15506	£7.89	360	20409	£6.64	£289.68	£2,840.40
11						£69,279.27	£18,645.70
Sheet1

Cell Formulas
Range	Formula
G3	=IF($B3="",$C3*$E3,$C3*$B3)

WBD

 

[Johnboy28]

Hi, like this maybe:

Excel 2013/2016

	A	B	C	D	E	F	G
2	Amended Code	Amended Price	Product Weight	Actual Code	Price/kg	Actual Value	Amended Value
3			150	16732	1.38	6,999.06	207
4			250	16902	7.59	17,742.82	1897.5
5			350	16953	2.89	4,090.01	1011.5
6	15506	7.89	650	16973	3.2	4,576.08	5128.5
7	26354	8.1	500	20104	7.79	16,115.59	4050
8			450	20112	4	652.06	1800
9			250	20147	6.87	18,813.97	1717.5
10	15506	7.89	360	20409	6.64	289.68	2840.4

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula G3 =C3*IF(ISNUMBER(B3),B3,E3) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you for your help. Works well.

 

[Johnboy28]

Thanks for your reply. I ended up using this formula. =C3*IF(ISNUMBER(B3),B3,E3)