i have a simple vlookup formula in one worksheet referenceing values in
another worksheet, ie ' =vlookup(B2,otherworksheet!A2:D37,3) '

the data has been sorted, but the vlookup function continues to return a
value from 'otherworksheet' that is physically one cell above the corect
cell. for example, if the value in B2 is found in row 23 of
'otherworksheet', i am getting the value from row 22 in 'otherworksheet'. i
have never had a problem like this. i have resorted the data several times
(ascending) and tried the regular lookup function, but i keep getting the
value ove cell above the target cell. thoughts?