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! Book time with me here: https://calendly.com/michelle-choate
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!