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 ID is being treated the same as a030900000OsXAo even though they are different IDs, because the letter 'a' is being treated same as 'A' in second ID.
The formula below in column S of my excel attached needs updating to recognize upper and lower text.
=IFERROR(VLOOKUP(A2,Lookup!J:L,2,FALSE),B2)
Help is appreciated!
Thanks
Jenny
- 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.
This is the idea:
=LET(names,$E$2:$E$10,return,$F$2:$F$10,r,MATCH(TRUE,EXACT(I2,names),0),INDEX(return,r))- 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))
