Access this solution immediately by signing up as a member of excelanswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Case Sensitive Vlookup
I have values in a cell that can consist of the following mixture of upper & lower case:
AB
aB
Ab
ab
Each of these relate to a unique user. I need to do a vlookup that looks up the value and returns the unique user name that sits in a cell next to the user id
Can someone tell me the right formula that would work?
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- MS excel 2007
- Participating Experts
- 3
- Solution Grade
- A
Log In
Stay Connected
Top Experts
-
mlmcc
10,880
0 points yesterday
Profile -
dlc110161
3,500
0 points yesterday
Profile -
jimpen
3,500
0 points yesterday
Profile -
rowanscott
2,200
0 points yesterday
Profile -
billprew
2,000
0 points yesterday
Profile -
imnorie
2,000
0 points yesterday
Profile -
kgreene
1,820
0 points yesterday
Profile -
harfang
1,800
0 points yesterday
Profile -
Netminder
1,000
0 points yesterday
Profile -
GRayL
1,000
0 points yesterday
Profile -
eeshahidt
868
0 points yesterday
Profile -
patrickab
668
0 points yesterday
Profile -
tilsant
664
0 points yesterday
Profile -
redrumkev
400
0 points yesterday
Profile -
dave4dl
400
0 points yesterday
Profile -
byundt
200
0 points yesterday
Profile -
CORBETTMJ
200
0 points yesterday
Profile -
pari123
200
0 points yesterday
Profile -
tagit
200
0 points yesterday
Profile -
broomee9
200
0 points yesterday
Profile -
Dave96
200
0 points yesterday
Profile
Posted on 2010-11-03 at 03:41:35ID: 34565479
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.