View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default Find a match and display a message

=if(a1="mmm....doughnuts","found","not found")
*******************
~Anne Troy

www.OfficeArticles.com


"Woody" wrote in message
...
I am just delving into Excel other than the basics and I am trying to find

a
way to search a row and if the variable is found I want to return to

another
cell a message like "Value Found" or something like that. Not sure which
Function to use.. Any ideas?

Thank you