I think the issue is not the lookup, but the excel data source which probably have to read differently in the lookup.

I am not getting any error message. I am...

Thanks a lot. There is 1 more issue related to this topic only but I want to start new topic for this