Get the data from other sheet (link), and automatic range the number of Invoice

Hai ?? anyone can help me ?
I want to link to other sheet (Master Data) and get the data.
And automatic Range the Number Invoice, that Group by Customer Name.

I have attached the example file (Examples 1.xls)

Thank's before

antoni

Perhaps you could use this formula:

=VLOOKUP(LEFT(D11,FIND(",",D11&",")-1),'Master Data'!$C$6:$D$13,2,FALSE)

Hello Bos ?? Thank's for help me. But your formula does'nt run on my sheet. I am using Ms. Office 2002 and 2003.
Or anyone can help me, please...

Thank's before

Hai ?? anyone can help me ?
I want to link to other sheet (Master Data) and get the data.
And automatic Range the Number Invoice, that Group by Customer Name.

I have attached the example file (Examples 1.xls)

Thank's before

antoni