Vlookup or min(collect)?

Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!