Lookup returning incorrect results

[glenlee]

Anybody have an idea why I keep getting incorrect lookup results.

In sheet 1, I have a list of "Sales Codes" in col A. In sheet 2, I
have a list of data that with column A for "Sales Codes" and column B
for associated "Sales Reps".

I want to insert a column in sheet 1 that contains lookup formulas to
pull the correct sales rep for each sales code . Both sheets are
sorted in ascending order by Sales code.

My lookup formula in sheet 1, Lookup col B:
=LOOKUP(A2,Sheet2!$A$2:$B$4,Sheet2!$B$2:$B$4)

The returned results from the above lookup formula are incorrect.

 

[Frank Kabel]

Hi
try for an exact match:
=VLOOKUP(A2,Sheet2!$A$2:$B$4,2,0)

 

[duane]

try this

=vLOOKUP(A2,Sheet2!$A$2:$B$4,2)

looks in col a of sheet2 for a2 and returns element from col b o
sheet2

presumably this formula is on sheet1 or some sheet besides sheet

 

[Domenic]

=LOOKUP(A2,Sheet2!$A$2:$B$4)

Hope this helps!

Anybody have an idea why I keep getting incorrect lookup results.

In sheet 1, I have a list of "Sales Codes" in col A. In sheet 2, I
have a list of data that with column A for "Sales Codes" and column B
for associated "Sales Reps".

I want to insert a column in sheet 1 that contains lookup formulas to
pull the correct sales rep for each sales code . Both sheets are
sorted in ascending order by Sales code.

My lookup formula in sheet 1, Lookup col B:
=LOOKUP(A2,Sheet2!$A$2:$B$4,Sheet2!$B$2:$B$4)

The returned results from the above lookup formula are incorrect

 

[glenlee]

thanks all....the suggestions worked great....