Index/Match based on a condition in another cell

Jeana
Jeana ✭✭✭✭✭✭

Hi,

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 #?

Ideas?

Thanks!

Jeana

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!