Forum Discussion
Solved
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 ...
- Yes, 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.
Thanks Patrick! almost there! The formula needs to lookup column A in 'Data' tab against column J in 'Lookup' tab and return column K in 'Lookup' tab. If the return gives an error, then it should return column B in the 'Data' tab. Hope my explanation is ok!
Yes, 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.
- Thank you so much Patrick! Much appreciated and has saved me so much time : )
- You're welcome!