Trying to multiply 2 cells- one contains a long IF & VLOOKUP statement


I have the following problem. I am trying to multiply the value of two cells. One is a numeric value entered into a form the other is the answer to a nested IF ( VLOOKUP) formula. I keep getting and #INVALID VALUE error.

I need the result to be a $ value that comes from the length of rental period selected multiplied by the $ value returned from the following formula -

=IF([Rental Period]1 = "Daily", VLOOKUP([Boom Lifts]1, {Boom Rates}, 2, false), IF([Rental Period]1 = "Weekly", VLOOKUP([Boom Lifts]1, {Boom Rates}, 3, false), IF([Rental Period]1 = "Monthly", VLOOKUP([Boom Lifts]1, {Boom Rates}, 4, false), false)))

The above formula will return a $ value pulled from another sheet based on answers in the form submitted.

Can anyone help?



Best Answers

  • Cindy Bowker
    Cindy Bowker ✭✭✭✭✭
    Answer ✓

    It has worked thanks so much for all of your help. I would like to get some more involved training on formulas but that might have to wait until after this Covid-19 crisis.

    Have a great day and stay safe.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!