#incorrect argument set - vlookup

Kyle Fritz

Hi There,

Probably a simple user error here but I can't seem to get this vlookup formula to work in my SmartSheet. I get the "#incorrect argument set" error

Here is the formula and the lookup range

Here is the lookup table. I want to look up the name from the range above and return the value in the "All Leaders" column below (column 3)

I've exported both sheets to excel and created the vlookup formula and it works. What am I doing wrong in SmartSheet. Thank you!

Ryan Sides

Hey Kyle, your first portion of the vlookup should be a single value. [Alliance partner]@row

Not the range [Alliance partner]1:[Alliance partner]22 you have in there now.

Then just copy the formula down or make it a column formula.

Also, if your columns in your second sheet ever move, your vlookup will break. You can use index/match instead

Kyle Fritz

Thank you Ryan! That worked. I was used to vlookup working to look up a range in excel. good to know.

Ryan Sides

Hey Kyle, your first portion of the vlookup should be a single value. [Alliance partner]@row

Not the range [Alliance partner]1:[Alliance partner]22 you have in there now.

Then just copy the formula down or make it a column formula.

Also, if your columns in your second sheet ever move, your vlookup will break. You can use index/match instead

Kyle Fritz

Thank you Ryan! That worked. I was used to vlookup working to look up a range in excel. good to know.