Invalid Data Error

Miranda

Hello,

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,

Sameer Karkhanis

Just replace the [Column 4]7 in your formula with 2 so that your formula looks like,

=VLOOKUP([Column 4]6, Site1:[Tear Sample Kits Qty]4, 2, false) 

Miranda

Thanks for the feedback, Sameer! Now, the formulas states it is unparseable... Any insight, why?

Paul Newcome

Double check you column names are matching the column names being used in the sheet.