Searchable List Box To Return Column Other Than Searched Column?

I need the searchable list box to return data one column to the right of the "searched" column data.

This works mostly with Data Validation.

Named range "validationlist" with "=OFFSET(Choice!$AC$4,,,COUNTIF(Choice!$AC$4:$AC$14,"?*"))"

D9 has a drop down control. Enter the cell and type "br" and click the drop down arrow. Mouse to choose an item from the list box. If you chose "brown" , it will be entered in the cell. The returned item should be "banana" from the other column. How to do this?

Once working the control needs to be used across the row in more cells: E9, F9... all the way out to W9. And there has will be a Lookup to pull data from elsewhere above D9.

This worksheet ultimately needs to be uploaded to Skydrive and used as a collaborative worksheet as a 'web app'.

See attachment and formula output below.

[Code]............

searchableListBox-EF1.xlsx‎