Comparing a single cell to range of cells
 

I'm using Excell 2003. I am trying to find a formula that will take the
text contents of Cell "A" and compare it to a range of cells
(containing text), if there is a match of "A" to any items in the range
I want to present a value of 1 (if true) and 0 (if false) into Cell
"B".

example:

A B Range
1 joe 1 joe
2 bill 0 frank
3 sally 0 linda
4 jeff 0 betty


Has anyone tried to do this?

Thanks,
BobC


---
Message posted from http://www.ExcelForum.com/

Comparing a single cell to range of cells
 

Boy that didn't format well...

column **********Column**********Range
A1 Joe **********B1 1************Joe
A2 bill***********B2 0************frank
A3 sally*********B3 0************ linda
A4 jeff**********B4 0************betty


Bob

--
Message posted from http://www.ExcelForum.com

Comparing a single cell to range of cells
 

Thank you, the second ISNA function cleans it up a bit. I think I ca
use this.

Thank you again for your help.

Bob

--
Message posted from http://www.ExcelForum.com