Index/Match based on a condition in another cell

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

Paul Newcome

Try something like this...

=IF(LEFT([Asset #]@row) = "V", first_sheet_index_match, second_sheet_index_match)

Paul Newcome

Try something like this...

=IF(LEFT([Asset #]@row) = "V", first_sheet_index_match, second_sheet_index_match)

Jeana

That worked and I'll be able to apply it to other scenarios as well.

Thanks!

Paul Newcome

Happy to help. 👍️