Hello,

Can anyone help me please. I have two worksheet and each contain vendor
code. I just want to match the vendor code and then return to their phone
number.

sheet 1

abc
def
ghi
jkl
mno
pqr
stu
vwx
yza

Sheet 2
vwx 262-5555
jkl 262-5556
pqr 262-5557
mno 262-5558
stu 262-5559
dej 262-5560
ghi 262-5551


Thanks