Lookup function doesn't work

[Frank]

I am using a lookup function to compare the results in sheet1 column 1 to
sheet2 column 2 and return the results of sheet2 column2. The function
seems to work for the first few entries, but then returns the wrong results
for some of the other entries.

I am using "=LOOKUP(A7,Sheet2!$A$2:$A$16,Sheet2!$B$2:$B$16)" and it is
copied down a column of text/numeric entries in the first sheet.

Has anyone else had problems with this?

Thanks.

-- Frank L

 

[Max]

Are the values in the lookup_vector
i.e. "Sheet2!$A$2:$A$16" in ascending order ?

 

[Frank]

No. But now they are and it works.

Thanks.

Are the values in the lookup_vector
i.e. "Sheet2!$A$2:$A$16" in ascending order ?

 

[Max]

Pleasure' Frank !
Thanks for the feedback