LinkBack URL
About LinkBacks
Hi, I can't find which formula to use for this
if f12 matches any of the words in w1:w9 then 1 if there is no match then nothing ""
i know this must be simple but i keep getting ### any help will be greatly appreciated
Hi, I can't find which formula to use for this
if f12 matches any of the words in w1:w9 then 1 if there is no match then nothing ""
i know this must be simple but i keep getting ### any help will be greatly appreciated
Last edited by lizsantiago07; 07-09-2012 at 07:28 PM.
One way...
Formula:
=IF(ISNUMBER(MATCH(F12,W1:W9,0)),1,"")
HTH
Regards, Jeff
Thx a lot jeffrey!!
You are most welcome. Glad it worked for you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks