PC Review


Reply
 
 
=?Utf-8?B?bmFmZXJyZXI=?=
Guest
Posts: n/a
 
      10th Oct 2007
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?
 
Reply With Quote
 
 
 
 
Zone
Guest
Posts: n/a
 
      11th Oct 2007
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?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
data ranges greg Microsoft Excel Discussion 4 15th Jan 2007 06:01 PM
Copy data in named ranges to a newer version of the same template to identical ranges handstand Microsoft Excel Programming 0 21st Aug 2006 03:51 PM
Optional Data Series & Missing Data in dynamic ranges? Matt Kruse Microsoft Excel Charting 0 3rd Nov 2004 08:38 PM
Data Ranges =?Utf-8?B?SmFuZSBH?= Microsoft Excel Worksheet Functions 0 20th Jan 2004 05:56 PM
Data Ranges Jeff Microsoft Excel Worksheet Functions 1 2nd Dec 2003 10:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:18 AM.