I feel like I know how to do this, but nothing I'm trying is working for me.
I have a listing of words in Column D, and a list of wildcard values I want to count in Column E. I want to make a value in Column F that says TRUE/FALSe based on whether or not the wildcard match the word. Somewhat like this
D E F
bat *at* TRUE
bats *og* TRUE
cats TRUE
dog TRUE
frog TRUE
frogs TRUE
fish FALSE
bird FALSE
I triedcopied down the F column, but it's not working and I'm not sure why.Please Login or Register to view this content.
This is really obvious and I know I'll feel dumb when someone helps me
Thanks in advance,
Adam
Bookmarks