Which formula to use?
Best Answer
-
=VLOOKUP( [Facility Name]@row, lookup_table, 2, false)
You'll need to click on the cross-sheet reference when you get to the lookup table part and select both columns in your lookup sheet.
Let me know if you have any questions.
Answers
-
Vlookup would work great for your needs! But you could use other methods as well.
-
=VLOOKUP( [Facility Name]@row, lookup_table, 2, false)
You'll need to click on the cross-sheet reference when you get to the lookup table part and select both columns in your lookup sheet.
Let me know if you have any questions.
-
So would it be something like:
=IF([Facility Name]=VLOOKUP{sheet 2 details with facility names}=VLOOKUP{sheet 2 details with address}
?????
-
oh so I select both columns on sheet two at one time. I was doing it seperate.
-
It works amazing!!!! Thank you
-
Awesome, yes you select both columns in the Vlookup. I'm glad you got it working! 👍️
-
Hi Mike,
Is there another way I can pull contact information from another sheet based off parameters defined @row level. So that when a ticket is entered in based off the Facility the appropriate POC details populate in the SS?
-
There are other formulas that can be used. A combination of Index/Match can be used. The method is nice because it doesn't depend on your items being in any particular order. I've never mastered it but you can do some searching for index match in the community and see what comes up.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!