Invalid Data Error


I am using vlookup to create a report table that will sum the total qty of an item based on which item is selected in that drop down. Here is my formula: VLOOKUP([Column 4]6, Site1:[Tear Sample Kits Qty]4, [Column 4]7, false)

When used, I get "#invalid data type error"

Table Image

How can I fix this error?

Thanks in advance,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!