Looking for help with IF(HAS function. If value not found, then do a vlookup.

Hi, my formula continues to return as #INCORRECT ARGUMENT SET.

I want the cell to return a value of ZERO if the referenced cell HAS the word Closure. If it doesn't then I want it to do a vlookup.

Here is my current formula returning the error:

=IF(HAS([Project Type]@row, "Closure", 0, VLOOKUP([File ID]@row, {TM Completed Transactions KPIs (workflow s Range 1}, 4, false)))

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @abaker,

Your syntax looks incorrect. Also, the range you are using in the VLOOKUP formula looks off - "{TM Completed Transactions KPIs (workflow s Range 1}", I left it out of the formula below.

This is what it should like: =IF(HAS([Project Type]@row,"Closure"),"0",VLOOKUP([File ID]@row, lookup_table, 4, false))

Hope this helps,

Dave

All comments

Monique Odom Stearn

Hello @abaker,

It looks like the formula just needs to be cleaned up a bit with the parentheses:

=IF(HAS([Project Type]@row, "Closure"), VLOOKUP([File ID]@row, {TM Completed Transactions KPIs (workflow s Range 1}, 4, false))

DKazatsky2

Hi @abaker,

Your syntax looks incorrect. Also, the range you are using in the VLOOKUP formula looks off - "{TM Completed Transactions KPIs (workflow s Range 1}", I left it out of the formula below.

This is what it should like: =IF(HAS([Project Type]@row,"Closure"),"0",VLOOKUP([File ID]@row, lookup_table, 4, false))

Hope this helps,

Dave

abaker

@Dkazatsky2 this did the trick, thank you!

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.