I wish to search "list 1" and "list 2" for specific text and return that text if present if either of the lists. Please see attached example
I wish to search "list 1" and "list 2" for specific text and return that text if present if either of the lists. Please see attached example
Please try
=IF(COUNTIFS(A2:B10,"*"&C2:C10),C2:C10,"")
That worked, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks