CODEWITHSUNDEEP
excel
Nick The Dick
Nick The Dick

Reputation: 113

Excel cell's row number as a function of other cell's values

I don't use Excel very often. I have D3=C3-L(600+B3*200) in my program which doesn't work. I would like to assign this expression the meaning of "D3 equals sum of C3 and the cell in column L with the row number (600+B3*200)". (B3*200 being natural is accounted for in my Excel program). Which functions should i employ? Thanks!

Upvotes: 0

Views: 136

Answers (2)

Dom
Dom

Reputation: 55

=C3+INDEX(L:L,600+(B3*200),1))

Index returns the value of a given reference intersection.

Upvotes: 0

BigBen
BigBen

Reputation: 49998

Just use INDEX, with L:L as the array and 600+B3*200 as the row_num:

=D3=C3-INDEX(L:L,600+B3*200)

Upvotes: 1

Related Questions