Issue with VLOOKUP # Incorrect Argument Set

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)

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

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.

Paul Charlebois SSDT

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,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.