Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data ranges | Excel Programming | |||
Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
Data Ranges | Excel Worksheet Functions | |||
IRR data in different ranges | Excel Worksheet Functions | |||
Data ranges | Excel Programming |