HLOOKUP with variable rows


M

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
 
Ad

Advertisements

T

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.
 
M

Max

Thats perfect, thanks!

T. Valko said:
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top