I need to return the value in the table array even if it only [I]contains part of [I] the look up value. eg look up value is BD1-22 and array has a cell with text of BD.