IF statement issues

[Ozzie2842]

I'm using the following formula to calculate prices for products. It works well if Cell C2 is blank. However, I want to look up a different price (column 3 in the vlookup) if we type anything in Cell C2.

=IF(D2="","",IF(C2="",VLOOKUP(D2,$I$2:INDEX($I$2:$K$20,COUNTA($I$2:$I$20),2),2,0)))

I'm not getting where to include this additional formula to get this to work=VLOOKUP(D2,$I$2:INDEX($I$2:$K$20,COUNTA($I$2:$I$20),3),3,0)))

If this is too confusing, I'll upload the spreadsheet. Thanks in advance for having a look.

Oz

 

[T. Valko]

I'm using the following formula to calculate prices for products. It works well if Cell C2 is blank. However, I want to look up a different price (column 3 in the vlookup) if we type anything in Cell C2.

=IF(D2="","",IF(C2="",VLOOKUP(D2,$I$2:INDEX($I$2:$K$20,COUNTA($I$2:$I$20),2),2,0)))

I'm not getting where to include this additional formula to get this to work=VLOOKUP(D2,$I$2:INDEX($I$2:$K$20,COUNTA($I$2:$I$20),3),3,0)))

If this is too confusing, I'll upload the spreadsheet. Thanks in advance for having a look.

Oz

Try this...

=IF(D2="","",VLOOKUP(D2,$I$2:INDEX($K$2:$K$20,COUNTA($I$2:$I$20)),2+(C2<>""),0))

 

[Ozzie2842]

You're the best, thank you.

 

[T. Valko]

You're the best, thank you.

You're welcome. Thanks for the feedback!