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     www.energyefficientbuild.com.   Sep 21, 2013

user dyegovasc (http://productforums.google.com/forum/?zx=auqs2gn0ypq8#!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.

Thanks!

https://docs.google.com/spreadsheet/ccc?key=0AjT7-UeYDyR7dEpBMERvMENiOFRSdlZodTM0bzZRM0E&usp=sharing

----------------------------------------------------------------------------------------------------------------------