multiple values in a cell

C2:C7 has single non-sequential numbers and B2:B7 has multiple numbers separated by commas in each cell. I want to match the C2 numbers in B2:B7 and get the output of the corresponding matching number in D2. Can anyone help me formulate this? Thanks

Hi, I have a column which contains several text separated by commas. I'm trying to see if it would be possible to have a formula which looks at the values in-between the commas and if that value is found on sheet 2 it will display its corresponding value from column two I don't even know if...

if i have a string "bob has white trousers" i want the formula to search multiple colours and return the value white. so my formula would contain something like SEARCH( "black", "white", "grey", "green", "blue") etc If it had multiple values i would want to just accept the first. I cant get my...

I am trying to search for multiple values in a cell and if it find one of them, I would like a text value assigned to the cell. Here is my formula so far. =IF(ISNUMBER(SEARCH(OR("ADK","DHEA"),C1)),"MMG Supplement","") I would like it to search C1 for the text value "ADK" or "DHEA" and if it...

Hi, this has been driving me crazy and i am unable to find a formula to drive me the result. Please refer to the below case. <tbody> A B C D e 234563; 234575; 564543 Apple Yes 234575 (Apple) 223344; 278923; 232324 mango No 232324 (Mango) 123456; 567890 banana Yes 123456 (Banana)...