Thank you for your responses. Please bear with me as I have very little experience. I have copied the LOOKUP formula provided by AliGW, but it gives me #N/A answer. The number is A1 currently is 3, so I would be hoping for a 2500 response since the value is between 1 and 25.