It should return whatever is in the cell ... what exactly are you getting?

"cindy" wrote:

I am trying to lookup a value and get a text response. Is there a problem
using the LOOKUP Function for this? I used this function to return a numeric
value with no problem.