With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, July 29, 2012
yogi_Compute Current Balance Row By Row Where A String Is Part of Entries Of Name Column In Another Sheet
Problem: some users have multiple user names listed within the same cell.
So far I know that using =VLOOKUP(A1;Sheet1!$A$1:$D$11;2;false) works for Single usernames. However I have cells that has multiple usernames for the same person recorded within the same cell. How do i modify VLOOKUP to search within the cell?