VLOOKUP across Multiple Sheets
Answers
-
#INCORRECT ARGUMENT SET
-
Hey @Raghavendra N
It looks like you're missing one VLOOKUP text in front of the light blue [RFID #]@row reference:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 π
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Updated Still Same issue
-
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?
Join us at Smartsheet ENGAGE 2024 π
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Can we Connect in Teams for 1 MIn Get This closed my email ID below
raghavendra.n@wdc.com
-
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:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 π
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!