Hi,
I have a table of data that consists of company names and there address, phone number and few other details.
I have a worksheet that searches through this data to pull in this data for a user that is searching for a particular company - the formula I use for this is;
=IF($D$8>"",IF(ISERROR(INDEX('\\srukfp02\users\aaron.burchett\Redirected\[Search1.xlsm]CREDITOR ADDRESSES'!$A$2:$K$1028,SMALL(IF('\\srukfp02\users\aaron.burchett\Redirected\[Search1.xlsm]CREDITOR ADDRESSES'!$A$2:$A$1028=$D$8,ROW($A$2:$A$1028)),ROW(1:1))-1,2)),"",INDEX('\\srukfp02\users\aaron.burchett\Redirected\[Search1.xlsm]CREDITOR ADDRESSES'!$A$2:$K$1028,SMALL(IF('\\srukfp02\users\aaron.burchett\Redirected\[Search1.xlsm]CREDITOR ADDRESSES'!$A$2:$K$1028=$D$8,ROW('\\srukfp02\users\aaron.burchett\Redirected\[Search1.xlsm]CREDITOR ADDRESSES'!$A$2:$K$1028)),ROW(1:1))-1,2)),"")
This works perfectly, but will only return the creditor that exactly matches the search criteria i.e. Microsoft. In reality i might have a few entries in my table for Microsoft; Microsoft, Microsoft corporation, Microsoft head office, etc.
I want to adapt this function so that we can search Microsft and any 'Company names' from the table with 'Micorsoft' will be pulled.
I posted this as a formula thread but not 1 reply, im no VBA expert but I think its to advanced for a formula and needs to be written in VBA.
Bookmarks