Sorry, think I misread it earlier

Try using a little coercion on the lookup value:
=VLOOKUP(A49480+0,Sheet2!$A$1:$B$103,2,0)
The "+0" will coerce text number to a real number for correct matching
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Stuart Maclean" wrote:
hi there apparently that didn't solve the problem - any other thoughts..
many Thanks for your help!!