HLOOKUP with variable rows
 

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

HLOOKUP with variable rows
 

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.

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
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

HLOOKUP with variable rows
 

Thats perfect, thanks!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Max" wrote in message
...
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