Forum Discussion
JennyHoA20181
Feb 10, 2023Brass Contributor
How to get Excel Vlookup formula to recognise lower and uppercase.
Hello, I need the formula below to recognize upper and lower text. For example column A contains Product ID a030900000OsXao. This value is being looked up in Lookup!J:L. The problem is that this ...
- Feb 10, 2023Yes, it wasn't clear why the original VLOOKUP included column L so I thought that might've been the return you wanted. I've updated my previous post.
JennyHoA20181
Feb 10, 2023Brass Contributor
Thank you so much Patrick! Much appreciated and has saved me so much time : )
Patrick2788
Feb 10, 2023Silver Contributor
You're welcome!