Combining HLOOKUP, INDIRECT and ROW Functions

Hi All,

Wondering if there is a way that my formula could auto pick up the data from next row instead of manually changing the row to 3 and so on. Please see my formula below:
=HLOOKUP(C$6,INDIRECT($A7&"!$B$6:$AA$56"),2,FALSE)

Thanks for your help in advance.
Taha

Maybe like this:

=HLOOKUP(C$6,INDIRECT($A7&"!$B$6:$AA$56"),ROWS(C$6:C6)+1,FALSE)

Thank you so much, Ali. It worked like a charm.

Take care,
Taha

You're welcome!

In the future, please do not cross-post the same query on other forums without links. See here to find out why: http://www.excelguru.ca/content.php?184