Lookup values

I

Ify

I have these to sheets (1 and 2) , but need to use them to produce
result as shown below.

Please I will appreciate it if any idea.

Sheet1

Cuatomers detail

cust.no L Name F.name
6132 ianga zayis
7140 Ba anj heg
8147 Shar Tuls
==============================
Sheet2

Customers relations

Rela.no relations name
8147 giun
augi
7140 muel
6132 imell
miuine
diebue
cleve
===========================================


Result needed to produce from the above two sheets

cust.no L Name F.name no.of relations
6132 ianga zayis 4
6132A ianga imell
6132B ianga miuine
6132C ianga diebue
6132D ianga cleve
7140 Ba anj heg
1
7140A Ba muel
8147 Shar Tuls 2
8147A Shar giun
8147B Shar augi


Thank you all
 
Top