Find a value in a row?

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

How do i find a value in a row?

I want to be able to search a row at a time.....if it finds it in any of the
columns for that row it will return a one else a 0?

thanks!
 
Fab,

With a formula?

If you are looking for a string that will exactly match a cell value in row
1:
=IF(ISERROR(MATCH("String value to find",1:1,FALSE)),0,1)

If you are looking for a number, say 3
=IF(ISERROR(MATCH(3,1:1,FALSE)),0,1)

Or you can use a cell reference:
=IF(ISERROR(MATCH(A2,1:1,FALSE)),0,1)

HTH,
Bernie
MS Excel MVP
 
Back
Top