Or what you are looking for is not present in the 1st column of the lookup range or there is an invisble difference, like non printable characters or one or more space before or after the string.
Eventually post a sheet. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|