HLOOKUP with variable rows

[Max]

Hi Guys,

I am using an HLOOKUP to find a certain cell in a row of column headings and
then return the information under that column heading in the same row of a
table, so that as i fill down, the formula will just return the corresponding
cell in the same row as the "look up value". Is there anyway i can ask excel
to do this please?

Thanks for you help,

Max

 

[T. Valko]

It sounds like you want the row number to increment as you copy down.

Try something like this:

=HLOOKUP(A$1,C$1:G$6,ROWS(A$1:A2),0)

That returns the first result from row 2 of the table. As you copy down the
row number will increment to 3, 4, 5 etc.

 

[Max]

Thats perfect, thanks!

It sounds like you want the row number to increment as you copy down.

Try something like this:

=HLOOKUP(A$1,C$1:G$6,ROWS(A$1:A2),0)

That returns the first result from row 2 of the table. As you copy down the
row number will increment to 3, 4, 5 etc.

 

[T. Valko]

You're welcome. Thanks for the feedback!