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)
 

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

HLOOKUP static cell reference 1
Trying to HLOOKUP a value from another sheet and display all the d 4
Hlookup-Drag to rows below 5
Nested hlookup/vlookup (possibly just an if statement though?!?) 1
How do i hlookup with the "row index number" changing 2
How to HLookup but return a value in a different column. 1
Macro to automatically hide rows based on 3 cells 2
Changing the Row_index_num via HLOOKUP 2

Top