Excel VLOOKUP Formula Exact Match video tutorial - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 2
sandeep
Hello
Could you please help me with this formula
I have 2 sets of data
In Column A I have list of 50k user names
In column B I have 5k usernames
I-m sure that all the column B usernames will present in a Column A list but want to make sure there is no miss matches in names, means the name should be in same way like no difference in lower case and upper case, name should match exactly in column A and column B
Thank you -
reply
Hello
Could you please help me with this formula
I have 2 sets of data
In Column A I have list of 50k user names
In column B I have 5k usernames
I-m sure that all the column B usernames will present in a Column A list but want to make sure there is no miss matches in names, means the name should be in same way like no difference in lower case and upper case, name should match exactly in column A and column B
Thank you -
reply
Andrius
Hi, I encountered a problem with vlookup, I have values similar to these: -A-123- and -A-B-123-, so if I look up for -A-123- and it is not present in the lookup table, it finds -A-B-123- any workarounds besides removing --- sign to find exact value?
reply
Hi, I encountered a problem with vlookup, I have values similar to these: -A-123- and -A-B-123-, so if I look up for -A-123- and it is not present in the lookup table, it finds -A-B-123- any workarounds besides removing --- sign to find exact value?
reply
Add a review, comment
Other channel videos
