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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks