Thursday, January 24, 2013

yogi_Search Column A For Specified String And In Case of Match Return Entries In Column B

                                          Google Spreadsheet  Post  #988

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 24, 2013
user nelipot said:(!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!
 Any help very much appreciated :)

following is a solution to the problem