Data Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Excel Highlighting duplicates 0
VBA set thick borders around non empty cells in range 0
Excel VBA 1
Excel 2013 Merge Data 2
setting one worksheet cell range reference to another worksheet 1
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Copy Range of data using VBA 0
How to copy only one value from range to worksheet 5

Back
Top