VLOOKUP across Multiple Sheets

Raghavendra N

#INCORRECT ARGUMENT SET

Genevieve P.

Hey @Raghavendra N

It looks like you're missing one VLOOKUP text in front of the light blue [RFID #]@row reference:

Cheers,

Genevieve

Raghavendra N

@Genevieve P. Updated Still Same issue

Genevieve P.

Hi @Raghavendra N

My apologies, I should have added that you need an IFERROR at the front for every additional VLOOKUP, other than the first one.

So if you have 3 VLOOKUps, you would use 2 IFERRORS. IF you have 5 VLOOKUPs, you would use 4 IFERRORS at the front. Does that make sense?

Raghavendra N

@Genevieve P. Can we Connect in Teams for 1 MIn Get This closed my email ID below

raghavendra.n@wdc.com

Genevieve P.

Hey @Raghavendra N

If you would like a coaching session over screen share, it looks like your plan and account is eligible to book Pro Desk sessions. These are 30 minute screen sharing sessions where you can ask about best practices, see: https://www.smartsheet.com/pro-desk

In regards to this specific formula, let me break this down a little.

The IFERROR Function says: if the first formula errors, do this next thing instead. That means if you had 2 sheets, it would look like this:

=IFERROR(VLOOKUP(first sheet), VLOOKUP(second sheet))

Or

=IF the( VLOOKUP(first sheet) returns No Match, then VLOOKUP(the second sheet))

Does that make sense? This means if you have a third sheet to check when the first two don't have a match, you would need a second IFERROR and VLOOKUP statement:

=IFERROR(IFERROR(VLOOKUP(first sheet), VLOOKUP(second sheet)), VLOOKUP(third sheet))

So in your case, you would need multiple IFERROR statements, one for each sheet:

=IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(VLOOKUP(first sheet), VLOOKUP(second sheet)), VLOOKUP(third sheet)), VLOOKUP(fourth sheet)), VLOOKUP(fifth sheet)), VLOOKUP(sixth sheet))

and so on.

That said, if you're looking at data across 11 sheets, I would highly recommend using a Report instead of using formulas in a sheet. Here's more information:

https://help.smartsheet.com/articles/2482079-select-source-sheets-for-report-builder

Cheers,

Genevieve