That looks promising. I've never used the vlookup formula, what do the 2,0
and 3.0 represent.

--
Cheers,


"Duke Carey" wrote:

Well, based on this example, the portions of the formula that change are in
columns B & C of Pricing Info.

Set up a table that looks like this (use the values for B3, C3, etc) and
name the table range Pricing

Pricing Info
Product col B col C
x B3 C3
y B4 C4

then use a formula like this

=(K16 + vloookup(F16,pricing,2,0))+$b$1+L16*vloookup(F16,p ricing,3,0)


"Chris" wrote:

Well, it's really the same formula but references different cells based on
pricing data on another worksheet. So =IF(F16="x",('Pricing
Info'!$B$3+K16)*$B$1+(L16*'Pricing Info'!$C$3),IF(F16="y",('Pricing
Info'!$B$4+K16)*$B$1+(L16*'Pricing Info'!$C$4),.........""))

x, y and the rest represent product configurations.
--
Cheers,


"Duke Carey" wrote:

Perhaps you can be a little more specific about how your formulas change
depending on the value in A1. Usually there are many ways to get to your
objective, but we need some specifics.

"Chris" wrote:

Hi,

I want to create an if function but I want to use more than 7 conditions and
it won't allow me. If I look in help it suggests using the lookup function
but from what I can see you can't use formulas as the result. As an example
I want to say if cell A1 is x then use this formulas, if cell A1 is z use
this other formula. And I need to do that 15 times. There must be a better
way rather than using a formula that is a mile and a half long.
--
Cheers,