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 for you help, I am not sure how to incorporate into my excel, so I will send an attachment in response to this post.
Here's the updated formula:
=LET(r,MATCH(TRUE,EXACT(A2,AppID),0),IFERROR(INDEX(AddProgramInfo,r),B2))