Vlookup cell isn't multiplying with another cell.

Hi guys 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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!