The 2 and the 3 tell Excel to use the data in the 2d or the 3d column of
range Pricing, in the row where the lookup value is found. The ,0 requires
an exact match and will return a #NA error if the lookup value is not found.
Without the ,0 you must have the lookup table sorted on the lookup value, and
Excel will do an approximate match

"Chris" wrote:

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,