Help on Row Index Number inside Hlookup

B

Bisleycat2002

New Member
Joined
Sep 17, 2002
Messages
41
Hi - Is there a way of inserting the row index number automatically into a Hlookup formula so that if I "drag" the Hlookup formula down the page it will automatically change the row index number accordingly?

Many thanks

B
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
Hello,

you could use row() and adjust it for the row you are in.

Why not post your formula?
 
Upvote 0
Sorted

I think it was a simple as "onlyadrafter" has suggested - I just didn't realise that inserting row() would work inside the hlookup but it seems that it does!

Thanks very much
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
EXCEL QUESTION SUMIF WITHIN A ROW
Replies
1
Views
102
excelhelpmepls1
E
P
  • Question
How to use a MATCH helper column containing rows from a different sheet and INDEX in an array formula to return based on data in the helper column?
Replies
0
Views
172
purekarting
P
M
  • Solved
Apply index and Match to retrieve a value
Replies
5
Views
176
Georgiboy
Georgiboy
A
  • Question
HLOOKUP External Source, but use Variable in the address
Replies
1
Views
298
Micron
M
C
  • Question
Index/Match | Index/Small Formula
Replies
5
Views
343
Eric W
Eric W

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top