Sunday, July 29, 2012

yogi_Compute Current Balance Row By Row Where A String Is Part of Entries Of Name Column In Another Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #661   Jul 29, 2012     www.energyefficientbuild.com.


user MysticEve said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/IcxyKBKF_Ds)
How to use VLOOKUP where the search criterion is only part of the text string
Goal: look up user's name and return their point balance.
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?

Spreadsheet can be found here:
--------------------------------------------------------------------------------------------------
following is a solution to the problem