Index/Match based on a condition in another cell

Jeana ✭✭✭✭✭✭


I'm trying to get INDEX/MATCH to pull in related data (based on Asset #) from different sheets. Here is a sample sheet.

When the user types in the Asset # (TYA10229) the formula pulls the description from another sheet (Roadmap Asset Catalog) based on a matching Asset #. This works great.

Here's what I'd like to do - If the Asset # typed in starts with a "V" look up the description from another sheet. So I'm thinking I could incorporate an IF statement before the INDEX/MATCH formula to look at the Asset # and pull from another sheet if the Asset # starts with a "V".

Will this theory work? Should I use CONTAINS or FIND, VALUE to determine if there is a "V" in the Asset #?




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!