Lookup troubles

[PeterPlumber]

I am trying to get information from one worksheet into anothe
worksheet. I have used the lookup function to do basically the sam
thing all within the same worksheet, and it seems to work fine, bu
when bringing it across worksheets, it doesn't wanna work. Here is th
scenario:

I have a labor table separated into levels of expertise. Each level ha
a text name, and they are listed in column 2 (or B). In the firs
column, I have a code number which correlates to each lever o
expertise. All this resides on Sheet 3 ('Labor Values').

On sheet 2, labor is assigned in a small table where the user of thi
workbook will select the code which corresponds to the level o
expertise and insert that code in cell E35, and give assign a number o
hours to that level in Cell F35. This method follows down the char
until all hours are assigned, so the codes may be in a range from E3
thru E45.

On my front sheet, I have set up a table to display: a) the labor code
b) the expertise level in text format, c) the base rate of pay for tha
skill level, d) the fringe benefits for that skill level, e) the numbe
of hours assigned to that skill level, and f) the PRODUCT of hour
times (rate + fringe).

So, in cell A65, I have the following: ='sheet 2'!E35

That brings in the labor code entered manually. Now I want Excel t
find the labor code displayed in A65 (which is brought in from sheet 2
on sheet 3 from the range of A1 thru A20 and and display the matchin
skill level in text format (sheet 3 B1 thru B20) in cell B65.

I have tried the following:

=LOOKUP(A65,'Labor Values'!A1:A20,'Labor Values'!B1:B20)

and several combinations of MATCH and INDEX, but I just am not gettin
anything but "#N/A"

I have also tried using range names, with the following:
=VLOOKUP(A65,LaborRates,2,FALSE)

Any suggestions

 

[Frank Kabel]

Hi
the following should work:
=VLOOKUP(A65,'Labor Values'!$A$1:$B$20,2,0)

 

[Kevin Stecyk]

PeterPlumber...

I am trying to get information from one worksheet into another
worksheet. I have used the lookup function to do basically the same
thing all within the same worksheet, and it seems to work fine, but
when bringing it across worksheets, it doesn't wanna work. Here is the
scenario:

Peter,

Problem was responded to worksheet.functions. (As an aside, some "numbers"
were text. Once the text was reformatted as numbers, vlookup worked
correctly.)

If you are still checking in Peter, please post your message in just one
section. The regulars here check all sections, so your message will get
caught quickly and responded to promptly.

Thank you Peter.

Best regards,
Kevin