Have a look at VLOOKUP in Help and then come back if more help is needed
But give as more details on your worksheet layouts
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Michael" wrote in message
...
There is a lot of information in each sheet and they need to be merged.
Each sheet had a unique ID which matches with each other (ie one sheet
hadd
addresses and the other has the phone number and they need to be merged
onto
one line to be inported into a database.)

Can someone please assist

thanks in advance.

Michael