HLookup Help

[hotflush]

Hi,
For example,
I want to lookup this table:

And fill up this table using HLookup:

=Hlookup(lookup_value,table_array,row_index_num,range_lookup)

I'm trying to do a HLookup but i want the row_index_num to increase as I copy down the rows.

How do I do this?

Thanks in advance.

 

[Sandeep Warrier]

Hi and welcome to the Board!

How about

Excel Workbook
	A	B	C	D	E
1	A	B	C	D	E
2	1	2	3	4	5
3	5	4	3	2	1
4	2	3	1	5	4
Sheet1

Excel 2003

Excel Workbook
	A	B	C	D
1	B	E	D	A
2	2	5	4	1
3	4	1	2	5
4	3	4	5	2
Sheet2

Excel 2003

Cell Formulas
Range	Formula
A2	=HLOOKUP(A$1,Sheet1!$A$1:$E$4,ROWS(A$1:A2),0)

 

[hotflush]

Hi Sandeep,

You solved my problem. Thank you very much.

 

[Sandeep Warrier]

You're welcome! Glad to help