VLOOKUP WITH MULTIPLE SHEETS

Camila Nunes

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

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. 👍️