good am. Welcome to the forum..
can you try this one.
=INDEX(A:A,MATCH("*"&D1&"*",B:B,0))
you're on excel 2010
you can use.
=iferror(INDEX(A:A,MATCH("*"&D1&"*",B:B,0)),"")
good am. Welcome to the forum..
can you try this one.
=INDEX(A:A,MATCH("*"&D1&"*",B:B,0))
you're on excel 2010
you can use.
=iferror(INDEX(A:A,MATCH("*"&D1&"*",B:B,0)),"")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks