LOOKUP into a different Sheet
 

I need to take data from a Sheet A "HLBFS_2007" into a Sheet "B", however the
in the source sheet the number of lines can vary but the lines where I need
the data from will be always there.

The data I am interested are in columns C to N of Sheet A, and the Column B
is unique name of the row, so I did :

=LOOKUP("01-02100 Transient Regular Rate
Revenue",HLBFS_2007!B1:B999,HLBFS_2007!C1:C999)

But it does not work it give me N/A.

Is there anybody who can tell me what I did wrong, I check on the other
questions but I could not find a similar answer. I know should be basic, but
I never used LOOKUP.

Thank you.
Aligi
--
Aligi

LOOKUP into a different Sheet
 

Try this vlookup (set for exact match):
In say, C2:
=VLOOKUP("01-02100 Transient Regular Rate
Revenue",HLBFS_2007!$B:$N,COLUMNS($A:A)+1,0)
Copy C2 across to N2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"Aligi" wrote:
I need to take data from a Sheet A "HLBFS_2007" into a Sheet "B", however the
in the source sheet the number of lines can vary but the lines where I need
the data from will be always there.

The data I am interested are in columns C to N of Sheet A, and the Column B
is unique name of the row, so I did :

=LOOKUP("01-02100 Transient Regular Rate
Revenue",HLBFS_2007!B1:B999,HLBFS_2007!C1:C999)

But it does not work it give me N/A.

Is there anybody who can tell me what I did wrong, I check on the other
questions but I could not find a similar answer. I know should be basic, but
I never used LOOKUP.

Thank you.
Aligi
--
Aligi