How to increase the row num in hlookup

B

bashaa

Joined
Oct 2, 2017
Messages
1
Reaction score
0
Hi,
can any one help me to increase row num automatically. I use to change manually for all the rows.

=HLOOKUP(L4,'[SS Production details till 28th September.xlsx]Sheet2'!$A$4:$O$5,2,0)
=HLOOKUP(L4,'[SRS Production details till 28th September.xlsx]Sheet2'!$A$4:$O$6,3,0)
=HLOOKUP(L4,'[SRS Production details till 28th September.xlsx]Sheet2'!$A$4:$O$7,4,0)
.
.
.
.
.
.
.
.
=HLOOKUP(L4,'[SRS Production details till 28th September.xlsx]Sheet2'!$A$4:$O$30,27,0)
 
Back
Top