Hi,
Please can you help me. I want to do separate table which lists all the products that contain the word "roll" in the product name and list their value too. Like in the attached.
Thanks in advance
Jenny
Hi,
Please can you help me. I want to do separate table which lists all the products that contain the word "roll" in the product name and list their value too. Like in the attached.
Thanks in advance
Jenny
Try this formula to return only the cells that contains "roll" :
=FILTER(A3:A10,ISNUMBER(SEARCH("roll",A3:A10,1)),"")
For the values you can use vlookup in column E :
=VLOOKUP(D4,A3:B10,2,0)
Attachment 742993
It seems to be doing a #SPILL! error
That is because there is data in the way. The formula returns an array. You only need to write the formula only once.
I attached an example file with the formula.
"Good Morning, Good Evening and Good Night"
I worked it out! THNAK YOU
I was dragging the formula down too far!
Do you know if there is a way of searching 2 words. for examples listing all products with the word "pie" and also products with the word "cider"? Also, do you know if there is a way to not include ones with the word pie and not with another word like "Pork"?
Formula to find pie and cider : =FILTER(A2:A5,ISNUMBER(SEARCH("pie*cider",A2:A5,1)),"")
Formula to NOT find pie and cider : =FILTER(A2:A5,IF(ISNUMBER(SEARCH("pie*cider",A2:A5,1)),FALSE,TRUE),"")
I also attached the file, check it to see if it's ok
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks