what I want this worksheet to do is when I enter company name in column D1 of sheet1 it should return me value of only that particular company in Result worksheet and can the cell D1 be made a suggestion giving like when I enter Ad it should suggest me adi hardware