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     www.energyefficientbuild.com.    Jan 24, 2013
user nelipot said:(http://productforums.google.com/forum/?zx=1bjq25opi7sr#!category-topic/docs/spreadsheets/mql5YU64wYU)
How do I recognise a pattern in spreadsheet? 

Hi
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

No comments:

Post a Comment