VLOOKUP WITH MULTIPLE SHEETS

Hi!

I´m trying to use VLOOKUP with IFERROR formula to find an information in more than one sheet, but it´s not working...

The formula I´ve been trying:

=IFERROR(VLOOKUP([SV / OS]@row;{Base Transações Intervalo 1};6;0),(VLOOKUP([SV / OS]@row;{Base Transações 02 Intervalo 1};6;0)))

It always return #UNPARSEABLE

I couldn´t find whats wrong...can anyone help me?

Thank you!

Camila

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Do you need commas or semi-colons in your formulas? If semi-colons, you have a comma separating the two VLOOKUP functions there in the middle of your formula.

Camila Nunes

Hi Paul,

Yes, I´m adding a comma separating the two VLOOKUP but it still return as #UNPARSEABLE

Paul Newcome

Right. What I am saying is that if you are supposed to be using semi-colons as separators, you need to change that comma to a semi-colon.

Camila Nunes

Changing to a semi-colon it return as #INVALID REF

Paul Newcome

Ok. A step in the right direction. At least now we have the syntax correct.

That particular error comes from a {cross sheet reference} that wasn't created. Make sure you are following the proper steps for creating your cross sheet references.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Camila Nunes

I made a change on the one of the sheets name and It worked now...

Thank you!

Paul Newcome

Happy to help. 👍️

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.