intersection function

T

tarheelrooster

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
 
S

Stefi

=INDIRECT(ADDRESS(K3,B4,1,1,"sheet2"))
where K3 - row number
B4 - column number

Regards,
Stefi


„tarheelrooster†ezt írta:
 

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

Intersection 5
Write to intersect of a row and column 7
intersection of a range 1
Intersection help 3
Collection Intersection Helper 7
using intersection of ranges 1
Who can help the NYPD with an Excel formula? 20
Calculating age 1

Top