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

Cindy Bowker

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.

Cindy

Paul Newcome

Happy to help! 👍️

Ryan Travers

https://community.smartsheet.com/discussion/comment/247931#Comment_247931

Hi guys, can you maybe also help me please Paul? Whenever I am trying to multiply my Vlookup cell with another cell it gives a Value error. I have linked web data to other sheets and have a vlookup for specific data in cell D6. In G6 I then want to multiply D6 by a value in F6 using =D6*F6, but a value error occurs. I have also tried copying and pasting the vlookup formula into G6 with *F6 on the end and also tried *f6,0) but value error also appears. When showing calculation steps the correct values are within the steps however on the final step it doesnt give the answer but value error. Please can someone help/let me know other ways as inputting the data manually everytime i refresh is very monotonous thanks in advance.

Paul Newcome

@Ryan Travers Exactly what is being pulled by the vlookup and exactly how is the data in the F column populated?