Finding multiple related contacts using VLOOKUP/INDEXMATCHING and returning phone number, email etc.

[moodoggy]

Hi everyone,

I just wanted to say thank you in advance for your time and help.

I have been tasked with sorting through 4,000 contacts and finding the telephone and mobile numbers and emails of any contacts that are related to a certain Account from a great list of 450. This relationship is determined by either direct reference to a certain Account Name in the Accounts or a cell in the FullName, Job Title, Organisation or notes column contains the Account Name in it.

I have tried VLOOKUP and MATCHING and INDEXING but have not been able to get it to find what I need. The primary issue is that 5 different contacts may be linked to one single Account (either found in their job title, organisation or whatever), and therefore I need to return multiple phone numbers, emails and other information that are linked to the 5 different contacts. VLOOKUP only found one contact and I have tried many different MATCHING and INDEXING solutions from examples and help sites but cannot get it to work.

Please see an example template of my contacts and the Accounts tab. There are obviously more and this data is fake.


[TABLE="width: 1209"]
<tbody>[TR]
[TD="align: center"]ACCOUNTS
[/TD]
[TD="align: center"]FirstName[/TD]
[TD="align: center"]LastName[/TD]
[TD="align: center"]FullName[/TD]
[TD="align: center"]Account Name[/TD]
[TD="align: center"]Job Title[/TD]
[TD="align: center"]Organisation
[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Chris[/TD]
[TD]Armstrong[/TD]
[TD]Chris Armstrong[/TD]
[TD]Redley[/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters[/TD]
[TD][/TD]
[TD]04 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]Christine[/TD]
[TD]Aarons[/TD]
[TD]Christine Aarons[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]Steven[/TD]
[TD]Aboud[/TD]
[TD]Steven Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]Michael[/TD]
[TD]Abeles[/TD]
[TD]Michael Abeles[/TD]
[TD]Abeles[/TD]
[TD][/TD]
[TD]Littleman Ltd[/TD]
[TD][/TD]
[TD]7 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]Armstrong[/TD]
[TD]Andrew[/TD]
[TD]Fairlight[/TD]
[TD]Andrew Fairlight[/TD]
[TD]Fairlight[/TD]
[TD]Executive Chairman[/TD]
[TD]Abercrom Ltd[/TD]
[TD][/TD]
[TD]8 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]Hunter[/TD]
[TD]Russell[/TD]
[TD]Andrews[/TD]
[TD]Russell Andrews[/TD]
[TD][/TD]
[TD][/TD]
[TD]GEY Ltd[/TD]
[TD][/TD]
[TD]9 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Allander[/TD]
[TD]Aboud[/TD]
[TD]Allander Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]George[/TD]
[TD]Abraham[/TD]
[TD]George Abraham[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Ground Investments[/TD]
[TD]11 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Chris[/TD]
[TD]Abry[/TD]
[TD]Chris Abry[/TD]
[TD]Abry[/TD]
[TD]Head of Research[/TD]
[TD]Investee Corp[/TD]
[TD][/TD]
[TD]12 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Menzie[/TD]
[TD]Acharya[/TD]
[TD]Menzie Acharya[/TD]
[TD][/TD]
[TD][/TD]
[TD]Carline Venture[/TD]
[TD][/TD]
[TD]13 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Josh[/TD]
[TD]Drickaya[/TD]
[TD]Josh Drickaya[/TD]
[TD]Drickaya[/TD]
[TD]Senior Portfolio Manager[/TD]
[TD]River Capital[/TD]
[TD][/TD]
[TD]14 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Robert[/TD]
[TD]Adlee[/TD]
[TD]Robert Adlee[/TD]
[TD]Hargraves[/TD]
[TD]Chief Executive Officer[/TD]
[TD]Parks Investment[/TD]
[TD][/TD]
[TD]15 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Kim[/TD]
[TD]Dryer[/TD]
[TD]Kim Dryer[/TD]
[TD]Dryer[/TD]
[TD]Office Manager/ EA to Robert Ell[/TD]
[TD]Leda Capital[/TD]
[TD][/TD]
[TD]16 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD]Michelle[/TD]
[TD]Hunter[/TD]
[TD]Michelle Hunter[/TD]
[TD]Caster[/TD]
[TD]Personal Assistant to Chairman & CEO[/TD]
[TD]Merene Group[/TD]
[TD][/TD]
[TD]17 3738 9873[/TD]
[TD="colspan: 2"]test@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]

 

[AliGW]

What are the expected outcomes using your sample data above?

 

[moodoggy]

What are the expected outcomes using your sample data above?

Please first note that the Accounts column is not linked to any rows and is just a LIST of the accounts.

For the output, say "Aboud" is contained in a long paragraph of Michelle Hunter's notes, Allander Aboud and Chris Aboud have the last name "Aboud" and George Abraham is the CEO of "Aboud's" Investment Team (not in the example above but should be). The expected outcome would be for Michelle's, Allander's, Chris's and Georges Full Name to be outputted, and in the same row, have their mobile numbers, telephone numbers and emails outputted.
I can then get in contact with these individuals that are somehow related to the Aboud Account.

 

[AliGW]

There is no notes column in your sample data. What we need is a properly REPRESENTATIVE sample of your raw data AND some expected outcomes in a table. You are leaving too much to our imagination at present.

 

[moodoggy]

There is no notes column in your sample data. What we need is a properly REPRESENTATIVE sample of your raw data AND some expected outcomes in a table. You are leaving too much to our imagination at present.

Sorry for my naivety. First time posting on a Forum to get help with Excel.

Updated Table

[TABLE="width: 1361"]
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]ACCOUNTS
[/TD]
[TD][/TD]
[TD]FirstName[/TD]
[TD]LastName[/TD]
[TD]FullName
[/TD]
[TD]Account Name[/TD]
[TD]Job Title
[/TD]
[TD]Organisation
[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email
[/TD]
[/TR]
[TR]
[TD]Aboud
[/TD]
[TD][/TD]
[TD]Chris [/TD]
[TD]Armstrong[/TD]
[TD]Chris Armstrong[/TD]
[TD]Redley[/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters[/TD]
[TD]Principal of Aboud Family[/TD]
[TD]04 3738 9873[/TD]
[TD]Chris .Armstrong@gmail.com[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD][/TD]
[TD]Christine[/TD]
[TD]Aarons[/TD]
[TD="colspan: 2"]Christine Aarons[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5 3738 9873[/TD]
[TD]Christine.Aarons@gmail.com[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD][/TD]
[TD]Steven[/TD]
[TD]Aboud[/TD]
[TD="colspan: 2"]Steven Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD]Steven.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD][/TD]
[TD]Michael[/TD]
[TD]Abeles[/TD]
[TD]Michael Abeles[/TD]
[TD]Abeles[/TD]
[TD][/TD]
[TD]Littleman Ltd[/TD]
[TD]Met with Michael on 13/09/15[/TD]
[TD]7 3738 9873[/TD]
[TD]Michael.Abeles@gmail.com[/TD]
[/TR]
[TR]
[TD]Armstrong[/TD]
[TD][/TD]
[TD]Andrew[/TD]
[TD]Fairlight[/TD]
[TD]Andrew Fairlight[/TD]
[TD]Fairlight[/TD]
[TD]Executive Chairman[/TD]
[TD]Abercrom Ltd[/TD]
[TD][/TD]
[TD]8 3738 9873[/TD]
[TD]Andrew.Fairlight@gmail.com[/TD]
[/TR]
[TR]
[TD]Hunter[/TD]
[TD][/TD]
[TD]Russell[/TD]
[TD]Andrews[/TD]
[TD="colspan: 2"]Russell Andrews[/TD]
[TD="colspan: 3"]Chairman of Aboud Investments[/TD]
[TD]9 3738 9873[/TD]
[TD]Russell.Andrews@gmail.com[/TD]
[/TR]
[TR]
[TD]Georgina[/TD]
[TD][/TD]
[TD]Allander[/TD]
[TD]Aboud[/TD]
[TD="colspan: 2"]Allander Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD]Daughter of Steven Aboud[/TD]
[TD]10 3738 9873[/TD]
[TD]Allander.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Chrysler[/TD]
[TD][/TD]
[TD]George[/TD]
[TD]Abraham[/TD]
[TD="colspan: 2"]George Abraham[/TD]
[TD][/TD]
[TD="colspan: 2"]Ground Investments[/TD]
[TD]11 3738 9873[/TD]
[TD]George.Abraham@gmail.com[/TD]
[/TR]
[TR]
[TD]Vertana[/TD]
[TD][/TD]
[TD]Chris[/TD]
[TD]Abry[/TD]
[TD]Chris Abry[/TD]
[TD]Aboud[/TD]
[TD]Head of Research[/TD]
[TD]Investee Corp[/TD]
[TD][/TD]
[TD]12 3738 9873[/TD]
[TD]Chris.Abry@gmail.com[/TD]
[/TR]
[TR]
[TD]Reagal[/TD]
[TD][/TD]
[TD]Menzie[/TD]
[TD]Acharya[/TD]
[TD="colspan: 2"]Menzie Acharya[/TD]
[TD][/TD]
[TD]Carline Venture[/TD]
[TD]Ex Chairman of Aboud Investments[/TD]
[TD]13 3738 9873[/TD]
[TD]Menzie.Acharya@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Josh[/TD]
[TD]Drickaya[/TD]
[TD]Josh Drickaya[/TD]
[TD]Drickaya[/TD]
[TD]Senior Portfolio Manager[/TD]
[TD]River Capital[/TD]
[TD][/TD]
[TD]14 3738 9873[/TD]
[TD]Josh.Drickaya@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Robert[/TD]
[TD]Adlee[/TD]
[TD]Robert Adlee[/TD]
[TD]Hargraves[/TD]
[TD]Chief Executive Officer[/TD]
[TD="colspan: 2"]Parks Investment[/TD]
[TD]15 3738 9873[/TD]
[TD]Robert.Adlee@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Kim[/TD]
[TD]Dryer[/TD]
[TD]Kim Dryer[/TD]
[TD]Dryer[/TD]
[TD]Office Manager/ EA to Robert Ell[/TD]
[TD]Leda Capital[/TD]
[TD]Met with Kim, interested in investing in new technology[/TD]
[TD]16 3738 9873[/TD]
[TD]Kim.Dryer@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Michelle[/TD]
[TD]Hunter[/TD]
[TD]Michelle Hunter[/TD]
[TD]Caster[/TD]
[TD]Personal Assistant to Steven Aboud
[/TD]
[TD="colspan: 2"]Merene Group[/TD]
[TD]17 3738 9873[/TD]
[TD]Michelle.Hunter@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]


Expected Outcomes (Highlighted cells indicate the cell that contains "Aboud")

[TABLE="width: 705"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]FullName
[/TD]
[TD]Account Name[/TD]
[TD]Job Title[/TD]
[TD]Organisation[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Chris Armstrong[/TD]
[TD][/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters[/TD]
[TD]Principal of Aboud Family
[/TD]
[TD]04 3738 9873[/TD]
[TD]Chris .Armstrong@gmail.com[/TD]
[/TR]
[TR]
[TD]Steven Aboud
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD]Steven.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Russell Andrews[/TD]
[TD][/TD]
[TD="colspan: 3"]Chairman of Aboud Investments
[/TD]
[TD]9 3738 9873[/TD]
[TD]Russell.Andrews@gmail.com[/TD]
[/TR]
[TR]
[TD]Allander Aboud
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Daughter of Steven Aboud
[/TD]
[TD]10 3738 9873[/TD]
[TD]Allander.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Chris Abry[/TD]
[TD]Aboud
[/TD]
[TD]Head of Research[/TD]
[TD="colspan: 2"]Investee Corp[/TD]
[TD]12 3738 9873[/TD]
[TD]Chris.Abry@gmail.com[/TD]
[/TR]
[TR]
[TD]Menzie Acharya
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Carline Venture[/TD]
[TD]Ex Chairman of Aboud Investments
[/TD]
[TD]13 3738 9873[/TD]
[TD]Menzie.Acharya@gmail.com[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

@moodoggy

Let A:J of Sheet1 house the sample you posted, including the headers in the first row.

A:K of Sheet2 houses the processing...

[TABLE="class: grid, width: 1123"]
<tbody>[TR]
[TD]Aboud[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IDX[/TD]
[TD]ACCOUNTS[/TD]
[TD]FirstName[/TD]
[TD]LastName[/TD]
[TD]FullName[/TD]
[TD]Account Name[/TD]
[TD]Job Title[/TD]
[TD]Organisation[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Aboud[/TD]
[TD]Chris[/TD]
[TD]Armstrong[/TD]
[TD]Chris Armstrong[/TD]
[TD]Redley[/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters[/TD]
[TD][/TD]
[TD]04 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Frazer[/TD]
[TD]Steven[/TD]
[TD]Aboud[/TD]
[TD]Steven Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]etc[/TD]
[TD]Allander[/TD]
[TD]Aboud[/TD]
[TD]Allander Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

A1 houses an item of interest.

In B1 control+shift+enter, not just enter:

=SUM(IF(MMULT(ISNUMBER(SEARCH(A1,Sheet1!$A$2:$K$15))+0,TRANSPOSE(COLUMN(Sheet1!$A$2:$K$15)^0)),1))

In A3 control+shift+enter, not just enter, and copy down:

=IF(ROWS($A$3:A3)>$B$1,"",SMALL(IF(MMULT(ISNUMBER(SEARCH($A$1,Sheet1!$A$2:$K$15))+0,TRANSPOSE(COLUMN(Sheet1!$A$2:$K$15)^0)),ROW(Sheet1!$A$2:$K$15)-ROW(Sheet1!$A$2)+1),ROWS($A$3:A3)))

In B3 just enter, copy across, and down:

=IF($A3="","",T(INDEX(Sheet1!$A$2:$K$15,$A3,MATCH(B$2,Sheet1!$A$1:$J$1,0))))

 

[moodoggy]

@moodoggy

Let A:J of Sheet1 house the sample you posted, including the headers in the first row.

A:K of Sheet2 houses the processing...

[TABLE="class: grid, width: 1123"]
<tbody>[TR]
[TD]Aboud[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IDX[/TD]
[TD]ACCOUNTS[/TD]
[TD]FirstName[/TD]
[TD]LastName[/TD]
[TD]FullName[/TD]
[TD]Account Name[/TD]
[TD]Job Title[/TD]
[TD]Organisation[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Aboud[/TD]
[TD]Chris[/TD]
[TD]Armstrong[/TD]
[TD]Chris Armstrong[/TD]
[TD]Redley[/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters[/TD]
[TD][/TD]
[TD]04 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Frazer[/TD]
[TD]Steven[/TD]
[TD]Aboud[/TD]
[TD]Steven Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]etc[/TD]
[TD]Allander[/TD]
[TD]Aboud[/TD]
[TD]Allander Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10 3738 9873[/TD]
[TD]test@gmail.com[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

A1 houses an item of interest.

In B1 control+shift+enter, not just enter:

=SUM(IF(MMULT(ISNUMBER(SEARCH(A1,Sheet1!$A$2:$K$15))+0,TRANSPOSE(COLUMN(Sheet1!$A$2:$K$15)^0)),1))

In A3 control+shift+enter, not just enter, and copy down:

=IF(ROWS($A$3:A3)>$B$1,"",SMALL(IF(MMULT(ISNUMBER(SEARCH($A$1,Sheet1!$A$2:$K$15))+0,TRANSPOSE(COLUMN(Sheet1!$A$2:$K$15)^0)),ROW(Sheet1!$A$2:$K$15)-ROW(Sheet1!$A$2)+1),ROWS($A$3:A3)))

In B3 just enter, copy across, and down:

=IF($A3="","",T(INDEX(Sheet1!$A$2:$K$15,$A3,MATCH(B$2,Sheet1!$A$1:$J$1,0))))

Hi Aladin,

Thank you very much for your thorough and excellent response!
I have got it working.

There is only one issue and sorry for not being clear before.

Instead of have "Aboud" at the top as a reference, I need to be able to reference "Aboud" from Column A in the below outcomes example. This will then allow me to auto-fill down all of the Account names which has been multiplied by 5 (in an attempt to get at least 5 contacts related to that Account).

Is there a better way of doing this so that it finds every contact that contains "Aboud" and further Accounts rather than just 5?

[TABLE="width: 799"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Acc Ref
[/TD]
[TD]FullName[/TD]
[TD]Job Title[/TD]
[TD]Organisation[/TD]
[TD]Notes[/TD]
[TD]Phone[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Chris Armstrong[/TD]
[TD]CEO at Capers Ltd[/TD]
[TD]Capters
[/TD]
[TD]Principal of Aboud Family[/TD]
[TD]04 3738 9873[/TD]
[TD]Chris .Armstrong@gmail.com[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Steven Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6 3738 9873[/TD]
[TD]Steven.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Russell Andrews[/TD]
[TD="colspan: 2"]Chairman of Aboud Investments[/TD]
[TD][/TD]
[TD]9 3738 9873[/TD]
[TD]Russell.Andrews@gmail.com[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Allander Aboud[/TD]
[TD][/TD]
[TD][/TD]
[TD]Daughter of Steven Aboud[/TD]
[TD]10 3738 9873[/TD]
[TD]Allander.Aboud@gmail.com[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Chris Abry[/TD]
[TD]Head of Research[/TD]
[TD]Investee Corp[/TD]
[TD][/TD]
[TD]12 3738 9873[/TD]
[TD]Chris.Abry@gmail.com[/TD]
[/TR]
[TR]
[TD]Aboud[/TD]
[TD]Menzie Acharya[/TD]
[TD][/TD]
[TD]Carline Venture[/TD]
[TD]Ex Chairman of Aboud Investments[/TD]
[TD]13 3738 9873[/TD]
[TD]Menzie.Acharya@gmail.com[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Andrews[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…
[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]Frazer[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[TD]…[/TD]
[/TR]
</tbody>[/TABLE]