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?
following is a solution to the problem
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