Thanks Andrew-R, this seems great, but when I change the content of the dropdown box, i.e. make a selection, nothing appears in the specfied cell, I'm wondering...

Are any of the items dependant certain heading fields? Such as line 8 where it mentions "lSEARCH_COL"?

I've atached the sheet, hoping that this makes more sense...GM sheet.xlsm