VLOOKUP for Multiple Sheets
Hi - I am trying to use VLOOKUP across multiple sheets.
I have one column that is labeled clinic #, and I want to search for this clinic number across 2 different sheets, and we want to display a specific cell from that line it pulls.
I have no problem doing a VLOOKUP for one of the sheets, I am running into an issue when trying to check the second sheet.
The current VLOOKUP formula I use for the single sheet is =VLOOKUP([Internal #]@row, {Electric Range 1}, 17, false)
Answers
-
First I would recommend INDEX/MATCH as a formula because it is much easier. Then you can add columns, or remove columns, or move columns in your source sheet and it will not matter.
Second, best practice is to name your ranges. So that way when you are having to troubleshoot a formula, or explain one six months later, you don't have to open every single one. So in this instance it would be INDEX({Electric - Named Range}, MATCH([Internal #]@row, {Electric - Clinic #},0)).
Now comes the tricky part - to pull two INDEX/MATCH formulas into one cell. I would need more info on what you are trying to pull in. Would it be possible to use an IF statement, or a JOIN or COLLECT formula?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!