Re: Data Ranges

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <naferrer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C10AA3D-9590-4D1E-BEE5-08720B50EF51@xxxxxxxxxxxxxxxx
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 work*** in another cell I need a formula that will allow to
look at the above cell then match that value to another work*** within
the
same book.

Does this make sense?


.

Quantcast