Data Ranges
 

I hope someone can help...

Here is what I'm trying to do:

In one cell place a number call it 1...

One the same worksheet in another cell I need a formula that will allow to
look at the above cell then match that value to another worksheet within the
same book.

Does this make sense?

Data Ranges
 

Say you want to know whether cell A1 on Sheet1 is the same as cell A1 on
Sheet2. In another cell on Sheet1, enter this formula:
=IF(A1=Sheet2!A1,True,False)

Hope this helps, James

"naferrer" wrote in message
...
I hope someone can help...

Here is what I'm trying to do:

In one cell place a number call it 1...

One the same worksheet in another cell I need a formula that will allow to
look at the above cell then match that value to another worksheet within
the
same book.

Does this make sense?