If it's text, it doesn't work - so you'd need to ensure that it returns the number as a number... add zero to the output of the lookup..