Can I use an If and lookup formula in one formula?

Vicki D.

I have two formula's that work separately and cannot get them to work together.

I have a formula that returns a $ figure with this formula. =LOOKUP(Level@row, [Sports Level]:[Base Rate], 2, false

Then I have this formula which returns a $0.00 with this formula =IF([Mobile Unit Base]@row > 0, "$0.00")

I am trying to get them both to work in the same cell and having little luck.

So if if doesn't return a 0.00, it will return the lookup value. (Also would like this to be usable as a column formula when it's all said and done if possible.)

Thanks for any help you can offer.

Vicki

Ross Ihrig

Have you given this a try? If this formula doesn't work, perhaps it is a data type issue.

=IF([Mobile Unit Base]@row > 0, "$0.00", VLOOKUP(Level@row, [Sports Level]:[Base Rate], 2, false))

Ross Ihrig

Have you given this a try? If this formula doesn't work, perhaps it is a data type issue.

=IF([Mobile Unit Base]@row > 0, "$0.00", VLOOKUP(Level@row, [Sports Level]:[Base Rate], 2, false))

Vicki D.

Thank you so much, this worked perfect! Looks like I didn't have VLookup only Lookup and maybe because I had the formula reversed. Appreciate the help.