CODEWITHSUNDEEP
excel
AresProductions
AresProductions

Reputation: 518

EXCEL how to set cell row from other cell value

Is there a way for me to set a row value from another cell value.

Example: A1 = B62 = 'HELLO'

C1 = 62

So instead of 62 I want to set the value of C1.

A1 = B(C1) which would equal B62.

I hope I explained it well :P

Update: This is the formula bar: =SUMIF('I1'!$C$2:$C$61,A2,'I1'!$F$2:$F$61) Want to change the both 61 to my V4 cell value. For example if V4 = 10. That would make =SUMIF('I1'!$C$2:$C$10,A2,'I1'!$F$2:$F$10)

Upvotes: 0

Views: 80

Answers (2)

Scott Craner
Scott Craner

Reputation: 152465

Use the non volatile INDEX()

=SUMIF('I1'!C$2:INDEX('I1'!$C:$C,$V$4),A2,'I1'!F$2:INDEX('I1'!$F:$F,$V$4))

Upvotes: 3

BruceWayne
BruceWayne

Reputation: 23283

You'll want to use Indirect.

In C1, place your row value (15, for example). Then, in cell A1, use =Indirect("B" & $C$1)

Then as you change the value in C1, the value in A1 will change.

Upvotes: 1

Related Questions