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" <(E-Mail Removed)> wrote in message
news:6C10AA3D-9590-4D1E-BEE5-(E-Mail Removed)...
>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?
|