Oct
9
comment Enhanced Vlookup Excel Formula
almost! The problem with this solution is that when somebody's name is (for example) "Johnson", his age would be be confused with someone who's name is "John". Thoughts?
Oct
9
comment Enhanced Vlookup Excel Formula
@EricF The screenshot in the question is provided based on dummy data. In reality, large raw data comes in this format from an external feed that we can't manipulate (so having the space seperated entries is inevitable). I am open for using VBA for this.
Oct
9
comment Enhanced Vlookup Excel Formula
@Raystafarian Thanks for the hint, I have updated the question
Oct
1
comment Enhanced Vlookup Excel Formula
@duDE I have updated the question.
Oct
1
revised Enhanced Vlookup Excel Formula
added 71 characters in body
Oct
1
asked Enhanced Vlookup Excel Formula
Sep
30
awarded Explainer
Aug
24
awarded Yearling
Aug
24
awarded Yearling
Aug
13
awarded Nice Answer
Jul
10
awarded Famous Question
Jul
2
awarded Curious
Jul
2
awarded Curious
Jun
17
awarded Popular Question
Jun
11
awarded Notable Question
May
19
awarded Yearling
May
13
asked Solaris noexec_user_stack Issues
May
13
asked Security Implications of Running Solaris Kerberos TGT Expiration Warning Deamon
May
7
awarded Popular Question
Apr
13
revised SMTP Headers Guide
added 1 characters in body
1 2 3 4 5