| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
intersection function
I have two worksheets. I want to enter 2 numbers in two different cells on
sheet 1 and then I want the result in a third cell to be the value of the intersection of the first two numbers I entered from sheet two. I.E. I want F5 to be the result (whats in the intersection) of the two numbers I enter in K3 and B4. Sorry if this is confusing |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
intersection function
tarheelrooster wrote:
I have two worksheets. I want to enter 2 numbers in two different cells on sheet 1 and then I want the result in a third cell to be the value of the intersection of the first two numbers I entered from sheet two. I.E. I want F5 to be the result (whats in the intersection) of the two numbers I enter in K3 and B4. Sorry if this is confusing What do you mean by "the intersection of two numbers"? Examples, please. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
intersection function
=INDIRECT(ADDRESS(K3,B4,1,1,"sheet2"))
where K3 - row number B4 - column number Regards, Stefi €˛tarheelrooster€¯ ezt Ć*rta: I have two worksheets. I want to enter 2 numbers in two different cells on sheet 1 and then I want the result in a third cell to be the value of the intersection of the first two numbers I entered from sheet two. I.E. I want F5 to be the result (whats in the intersection) of the two numbers I enter in K3 and B4. Sorry if this is confusing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Intersection | Charts and Charting in Excel | |||
| Intersection | Excel Discussion (Misc queries) | |||
| Intersection help | Excel Discussion (Misc queries) | |||
| Intersection | Excel Discussion (Misc queries) | |||
| I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
Linear Mode
