Google sheets: How do I return a text value based on a column matching an entire range?-CodePudding

Home > Back-end > Google sheets: How do I return a text value based on a column matching an entire range?

Google sheets: How do I return a text value based on a column matching an entire range?

Time：10-20

I need help returning a text value "WIP" based on column A matching an entire range.

The range has digits which users will input that match column A but cells will have more than 1 digit which will be seperated by a comma.

I'm not clear on how to do this so i'm stuck somewhere with:

Sumproduct, isnumber, and match yet i'm struggling how to yield a result.

Could you please help?

Thanks a lot!

Spreadsheet link: