That works perfect! Thank you so much

"Dave Peterson" wrote:

When you look at the results of these 4 formulas, do you see at most one non ""
cell?

If yes, you could use a 5th formula:

=x1&x2&x3&x4

(x1, x2, ... are the cells with those formulas)

or even:

=IF(ISNUMBER(MATCH(B2,Suggest!B1:Q1,0)),"Add","")
&IF(ISNUMBER(MATCH(B2,Suggest!B2:I2,0)),"Add"," ")
&IF(ISNUMBER(MATCH(B2,Suggest!B3:Q3,0)),"Delete or Remove","")
&IF(ISNUMBER(MATCH(B2,Suggest!B4:AO4,0)),"Delet e or Remove","")

All one cell.

(concatenating "" with other text won't hurt.)

Woody wrote:

Okay I got it all working with the following looking at 4 rows and returning
the results to 4 different cells. I was trying to make it as one function now
so I can have the result returned to 1 cell. I would use the OR somehow but
can not seem to get the syntax right.

=IF(ISNUMBER(MATCH(B2,Suggest!B1:Q1,0)),"Add","")
=IF(ISNUMBER(MATCH(B2,Suggest!B2:I2,0)),"Add","")
=IF(ISNUMBER(MATCH(B2,Suggest!B3:Q3,0)),"Delete or Remove","")
=IF(ISNUMBER(MATCH(B2,Suggest!B4:AO4,0)),"Delete or Remove","")

Thanks for all the great help..

"Dave Peterson" wrote:

Once your list hits 257 elements, you'll be happier to have used columns <vbg.

Woody wrote:

Never Mind.. I just got it... I just realized that A:A is searching the
column not the row.. So when I changed it as a test to A1:F1 that worked.

Thanks all again

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson