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.
Thursday, January 24, 2013
yogi_Search Column A For Specified String And In Case of Match Return Entries In Column B
user nelipot said:(http://productforums.google.com/forum/?zx=1bjq25opi7sr#!category-topic/docs/spreadsheets/mql5YU64wYU) How do I recognise a pattern in spreadsheet?
I am working in a spreadsheet and I need to lookup a value e.g. 200 A U406 ICF-CHK 31AUG10_G held in cell A1
and return the full title referenced in another sheet and return the full title.
Full title generally looks something like this 200 A U406 ICF-CHK 31AUG10_G Informed Consent Form Checklist for Main Informed Consent Form as you can see only the first part is the same and sometimes the length differs. I have tried using FIND, MATCH etc but am struggling!