Saturday, September 21, 2013

yogi_Pull The Corresponding Color From Column B Of database If A Part Of Entry In Column A of index Matches Entry of database Column A

                                          Google Spreadsheet   Post  #1376
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep 21, 2013
user dyegovasc (!category-topic/docs/spreadsheets/hF1wD9ULYjQ)
autocomplete column based on string search from another sheet (maybe VLOOKUP) Google Spreadsheets
I`ve been trying to solve this for a while but without success. Maybe someone can help me.
PROBLEM: when a cell in column A contains a string from column A from sheet 'database', then autocomplete cell in column B with corresponding value from column B in sheet 'database'
I need to autocomplete column B in sheet 'index'
Ive published a spreadsheet explaining better what Im looking for.