hlookup problem

[Libra0099]

Hi every one,

I have a problem using hlookup.

Senario is like that:

Column ColumnA ColumnB ColumnC
Heading 60258 60259 60260
Now i have to pick data from a range of row e.g from row 1 to row 1000


i apply formula =hlookup(heading, range 1 to 1000, row 1, 0)

in next row i need to auto update the return value by row 2 then row 3 and so on.

Please help me.

Thanks in advance.

 

[ExcelChampion]

I assume you are dragging this down...

=HLOOKUP(HEADING,$1:$1000,ROW(A1),0)

HTH!

Edit: You nearly had it in your example above.

 

[Libra0099]

Thank you.

It helps me alot.