Help on Row Index Number inside Hlookup

[Bisleycat2002]

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

 

[onlyadrafter]

Hello,

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

Why not post your formula?

 

[Andrew Poulsom]

What's your original formula and what do you want to happen to the row index when you drag it down?

 

[Bisleycat2002]

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