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

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

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