• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

repeat INDIRECT in single cell without any arithmetic operator

xlstime

xlstime

Active Member
Hi Friends,

Please help me to understand, I saw somewhere that someone used indirect function twice in a cell without using arithmetic operator

=INDIRECT(J2) INDIRECT(K2)

Please help me to understand this formula
 
Placing a space between two references will return only the cells that intersect those ranges. This concept is easier to understand with a different example.

=SUM(A:A 2:3)

This formula has 2 ranges: A:A and 2:3. The intersection of these is A2:A3. The SUM would then return the value of A2 + A3. Now, what if we left off the SUM function, like so?

=A:A 2:2

The intersection of these two ranges is a single cell, A2, so the formula will still work. This last one is a pretty close example to what you had. Each of the INDIRECT functions is generating a range, and the overall formula then will look at the intersection of those two ranges.
 
Thanks Luke!.

Luke M said:
Placing a space between two references will return only the cells that intersect those ranges. This concept is easier to understand with a different example.

=SUM(A:A 2:3)

This formula has 2 ranges: A:A and 2:3. The intersection of these is A2:A3. The SUM would then return the value of A2 + A3. Now, what if we left off the SUM function, like so?

=A:A 2:2

The intersection of these two ranges is a single cell, A2, so the formula will still work. This last one is a pretty close example to what you had. Each of the INDIRECT functions is generating a range, and the overall formula then will look at the intersection of those two ranges.
Click to expand...
T
 
Luke M said:
Placing a space between two references will return only the cells that intersect those ranges. This concept is easier to understand with a different example.

=SUM(A:A 2:3)

This formula has 2 ranges: A:A and 2:3. The intersection of these is A2:A3. The SUM would then return the value of A2 + A3. Now, what if we left off the SUM function, like so?

=A:A 2:2

The intersection of these two ranges is a single cell, A2, so the formula will still work. This last one is a pretty close example to what you had. Each of the INDIRECT functions is generating a range, and the overall formula then will look at the intersection of those two ranges.
Click to expand...


Thanks buddy! Learned something new today!
 
You must log in or register to reply here.
Back
Top