Comparing a single cell to range of cells

B

BobC

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
 
B

BobC

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
 
B

BobC

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

Thank you again for your help.

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top