Hi, I hope someone can help with this problem.
I have a spreadsheet with a list of company names in column A, I want a search function that allows users to type in a company name and it returns the corresponding info in the columns B,C,D,E etc.
I have the following formula and it works perfectly; =IF(ISERROR(INDEX('CREDITOR ADDRESSES'!$A$2:$K$1028,SMALL(IF('CREDITOR ADDRESSES'!$A$2:$A$1028=$D$8,ROW($A$2:$A$1028)),ROW(1:1))-1,2)),"",INDEX('CREDITOR ADDRESSES'!$A$2:$K$1028,SMALL(IF('CREDITOR ADDRESSES'!$A$2:$K$1028=$D$8,ROW('CREDITOR ADDRESSES'!$A$2:$K$1028)),ROW(1:1))-1,2))
However, I would like it modifying so that it returns a partial name i.e. rather than putting in 'Microsoft', users can put in 'Micr' and it will return all the corresponding info from the cells with 'Micr' in column B.
The reasoning behind this is because the long list of companies in comlumn B do have slight variations i.e. I might have 'Microsoft' and 'Microsoft Corporation'. It would be ideal if we could return all of these variations.
Thanks for any help in advance.
Bookmarks