Hi Vadhimoo,

Instead of a UDF, try using Excel's VLookup function.

See Excel's help for details or see Debra Dalgleish at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Vadhimoo" wrote in message
...
Hi ,

I am havinng two work books like:

Workbook1.Sheet1:

Date TransferID SupName Amount
10/20/2006 001 MCI 25000
11/11/2005 101 AT&T 50000
12/12/2006 301 Orange 35000
........... .... ...... .......
........... ..... ...... .......

Workbook2.Sheet1:

SupName SupNo
Tele2 2001
AT&T 3001
MCI 5001
Orange 6001
....... ......
....... .......


I need the UDF , result should be like this in the Workbook.Shee1:

Date TransferID SupName Amount SupNo
10/20/2006 001 MCI 25000 5001
11/11/2005 101 AT&T 50000 3001
12/12/2006 301 Orange 35000 6001
........... .... ...... .......
........
........... ..... ...... .......
.......