INCORRECT ARGUMENT SET on an =IF function

I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's column. If there is something in the "second HRBP contact info" column, I want that info to be pulled in.

=IF(ISBLANK({Departmental HRBP Contact Range 4}), "", VLOOKUP(Department@row , {Departmental HRBP Contact Range 3}, 4, false))

It keeps on returning an INCORRECT ARGUMENT SET error, but I myself can't think of anything wrong. Thoughts?

Find more posts tagged with

Human Resources

Formulas

Accepted answers

Jgorsich

Incorrect argument set can come from missing an argument (which doesn't seem to be the case) or from having misaligned ranges. In this case, your {Departmental HRBP Contact Range 4} seems to be potentially the cause of the problem. I just tried a version of your function on a test sheet and it looks like isblank() needs to evaluate at the cell level. Try switching isblank() to "if(count({Departmental HRBP Contact Range 4})=0"

All comments

Jgorsich

Shannon H.

That worked! Thank you so much.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.