Iferror using multiple sheets

whitemd1964

Hello,

I have a sheet titled "4G Cradlepoints" with the serial number in the first column, Column name is "Serial Number". Each serial number is listed once. I have another sheet named "All Sites" and the 60th Column is named "4G Cradlepoint SN". The serial number will be listed multiple times in the "All Sites" sheet (representing which site it was used at)

I want to look for the serial number listed in row of the "All Sites" sheet in the "4G Cradlepoint" sheet and retrieve the current value in 13th Column (Column is named "Status" and place it in the column labeled "4G Find Status" of the "All Sites" sheet for each row.

I have been trying to use the Iferror function, but I keep getting #UNPARSEABLE error.

Find more posts tagged with

Accepted answers

All comments

heyjay

Can you show your formula? Pattern should be something like the one below. Unparsable seems like a misplaced punctuation (comma, parenthesis, etc)

=IFERROR(working_formula,formula_iferror)

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.