IF and Vlookup Statement

Jack Nguyen

I'm not sure if should I do it right

What I would like to achieve:

Smartsheet A - with list of the application name and ID

Smartsheet B - will collect information from Smartsheet A

I use if statement below and give me error # INVALID OPERATION

=IF({import Info Range 1}="PDI", VLOOKUP([Primary Column]@row, {import Info Range 2}, 3, true))

thx!

Find more posts tagged with

Accepted answers

Paul Newcome

I would suggest something more along the lines of...

=INDEX(COLLECT({Other Sheet Column To Pull From}, {Other Sheet Station Column}, "PDI", {Other Sheet Column4}, [Primary Column]@row), 1)

Jack Nguyen

=INDEX(COLLECT({import Info Range 4}, {import Info Range 1}, "PDI", {import Info Range 5}, [Primary Column]@row), 1)

and I got error '# invalid Column Value '

All comments

Paul Newcome

I would suggest something more along the lines of...

=INDEX(COLLECT({Other Sheet Column To Pull From}, {Other Sheet Station Column}, "PDI", {Other Sheet Column4}, [Primary Column]@row), 1)

Jack Nguyen

=INDEX(COLLECT({import Info Range 4}, {import Info Range 1}, "PDI", {import Info Range 5}, [Primary Column]@row), 1)

and I got error '# invalid Column Value '

Paul Newcome

Make sure the column types on both sheets match.

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.