Nesting Iferror function

[joniofok]

I have the following formula, =IFERROR(VLOOKUP(J2,Price!A1:E50,3,FALSE),0) it returns a value from the third column of another worksheet that lists prices of our product, however we have changed our prices and now have 5 columns, so if cell d2 says old i need cell j2 to return a price from column 3 of my table array, but if it says new i need it to return a price from column 5. I've tried it 10 different ways and i just can't get it to work, any ideas please?

 

[Luke M]

=IFERROR(VLOOKUP(J2,Price!A1:E50,IF(D2="old",3,5),FALSE),0)

 

[fred]

you need to change the number "3" in your original formula into a if formula.


If(d2="old",3,5) or something like this.

 

[fred]

lol Luke beat me by a minute again!


Note to self: cut the jabbers.

 

[Luke M]

<sneaky ninja grin>

 

[joniofok]

Thank you so much!!!!!!!!!!!!!! Apparently i was making it much harder than i needed to, at one point yesterday i had a formula with 2 different vlookups, and 3 if errors....so much easier, bless you!!

 

[Luke M]

You're very welcome. =)