Vlookup or min(collect)?



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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!