Let's say column A1, B1, C1 contain values like ABC, DEF, GHI
Column D:D contains a number of random three letter values.
If it finds ANY of the criteria from A1,B1 or C1 in D:D it will return a TRUE. Otherwise if there are no matches it should return a FALSE.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Here's an example sheet https://docs.google.com/a/advantagep...7is/edit#gid=0
Sweet! I owe you a coke.Originally Posted by Fotis1991
Formula:Please Login or Register to view this content.
I'll remember that!
Followup question. Is there a way to have this ignore any blank cells in D:D column?
What do you mean? Ignore for what? Can you give me an example?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks