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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives