Can I use an If and lookup formula in one formula?
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
Best Answer
-
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))
Answers
-
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))
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives