Another Excel question

Use =IfNA((formula),Whatever you want to happen if it finds the error)
"" would mean it does nothing - it shows a blank cell
And they are right - trim should get rid of what you are looking for. But you can also download a little adding - will get the name for you.

Actually they have removed it. I used Power Query for most things these days.

You can specify how close your match should be. Much like the tool used to do. Blame age. I have it loaded on the other machine - but that is not with me right now.

https://appsource.microsoft.com/en-us/product/office/wa200004933?tab=overview
They never used to charge for it
Power query would also be a good choice, but then you have to explain to the user how tables and keys work.
 
Back
Top