| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a match and display a 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a match and display a message
Ok that works thanks.. Is it possiable to have multiple IF's on the same line?
Where if the value I put in is A or B or C or D it returns the value? example: =if(a1="A;B;C;D","found","not found") "Anne Troy" wrote: =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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a match and display a message
maybe this is what you're looking for
=IF(OR(A1="a",A1="b",A1="c",A1="d"),"found","not found") -- Gary "Woody" wrote in message ... Ok that works thanks.. Is it possiable to have multiple IF's on the same line? Where if the value I put in is A or B or C or D it returns the value? example: =if(a1="A;B;C;D","found","not found") "Anne Troy" wrote: =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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a match and display a message
Oh nice thanks.. I would need to do this for 80 variables. Is there a better
way to have it look at a whole Row? "Gary Keramidas" wrote: maybe this is what you're looking for =IF(OR(A1="a",A1="b",A1="c",A1="d"),"found","not found") -- Gary "Woody" wrote in message ... Ok that works thanks.. Is it possiable to have multiple IF's on the same line? Where if the value I put in is A or B or C or D it returns the value? example: =if(a1="A;B;C;D","found","not found") "Anne Troy" wrote: =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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a match and display a message
how about posting an example of what you have and what you would like?
-- Gary "Woody" wrote in message ... Oh nice thanks.. I would need to do this for 80 variables. Is there a better way to have it look at a whole Row? "Gary Keramidas" wrote: maybe this is what you're looking for =IF(OR(A1="a",A1="b",A1="c",A1="d"),"found","not found") -- Gary "Woody" wrote in message ... Ok that works thanks.. Is it possiable to have multiple IF's on the same line? Where if the value I put in is A or B or C or D it returns the value? example: =if(a1="A;B;C;D","found","not found") "Anne Troy" wrote: =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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a match and display a message
If you have 80 things to look through, I'd insert a new worksheet and put those
80 terms in A1:A80. Then I could use: =if(isnumber(match(a1,sheet2!a:a,0)),"Found","not found") Woody wrote: Oh nice thanks.. I would need to do this for 80 variables. Is there a better way to have it look at a whole Row? "Gary Keramidas" wrote: maybe this is what you're looking for =IF(OR(A1="a",A1="b",A1="c",A1="d"),"found","not found") -- Gary "Woody" wrote in message ... Ok that works thanks.. Is it possiable to have multiple IF's on the same line? Where if the value I put in is A or B or C or D it returns the value? example: =if(a1="A;B;C;D","found","not found") "Anne Troy" wrote: =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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| Display a message | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| How to display a message box | Excel Programming | |||
Hybrid Mode
