Vlookup or min(collect)?
Hello,
Can i do a partial vlookup of a name? Specifically, i have an equipment list but the equipment is varied across each project. So instead of matching the entire name, can i do a partial lookup? I've got the contains statement but how do i tie it location ID?
=VLOOKUP({Electrical Equipments Procurement Tracker Range 1}, CONTAINS("switchboard", @Location ID), 10, true)
If that is not possible, maybe an alternative method could work. My current formula is able to output my earliest and latest equipment arrival dates. This is helpful, but i'd like to see what the name of the equipment it is that it is selecting.
=MIN(COLLECT({Electrical Equipment Tracker Range 1}, {Electrical Equipment Tracker Range 2}, [Location ID]@row))
Lastly, i want to pull the equipment from two different sheets. I want to do and if else statement based on the location ID.
Thanks!
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!