Issue with VLOOKUP # Incorrect Argument Set

Options

Hello,


I have a VLOOKUP formula that works in on sheet and not another. I am perplexed asw I get: '# Incorrect Argument Set' as an error.


=VLOOKUP(Department@row, {ShowSDT Departement/Responsable Range 1}, 2, false)

The above if the formula:

Department@row is a dropdown list cell wich contains the department name.

ShowSDT Departement/Responsable Range 1 - Looks for the resposable deparment in the 1st column in that sheet.

2 - to return a person email in the sheet

false - exact match - as both the dropdown list names and the look up sheet names are indentical

It works in a test sheet, this is the test sheet formula:

=VLOOKUP(Departement@row, {ShowSDT Departement/Responsable Range 1}, 2, false)

Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Options

    You have misspelled the column name in the one of the sheet -- Department@row OR Departement@row use whichever is correct or correct the column name in the appropriate sheet.

  • Thanks SK, the spelling is correct as this is a French sheet, however going back and creating the formula again, I noticed I had not seleected the 2 reference colums in my lookup sheet.

    Hopefully Smartsheet can address this, as there is no visual way to see what columns are selected if your referenced lookup sheet is used by several diffeferent formulas.


    Best,