Cell Lookup & Return value

[ChrisParkinson]

Hi All,

Hope somebody can help me, i have a problem.

I have some data - see below, i want to return a specific value if a cell contains certain text.

So for example if my cell Orderitems contains the text SDA1654 & SDA1585 & SDA1576 the return SDA1000

Warehouse	Channel	OrderItems
Main Warehouse	Studio	SDA1654:4;SDA1585:4;SDA1576:4;
Wrexham Warehouse	Studio	SDA1655:1;SDA1586:1;SDA1577:1;
Dropship Warehouse	Studio	SDA1656:1;SDA1578:1;SDA1587:1;

Any help would be appreciated.

Chris

 

[steve the fish]

Try this:

=IF(AND(ISNUMBER(SEARCH({"SDA1654","SDA1585","SDA1576"},C2))),"SDA1000","no")

 

[ChrisParkinson]

you beauty

tks

 

[ChrisParkinson]

worked like treat

?