Which formula can I use to get product names to transfer onto other sheets?
Like:

Sheet1:
ITEM# NAME
T0589 Rose
T0575 Lilly
T0575 Tulip

Sheet2:
ITEM# NAME
T0589
T0575

I would like for it to recognize the item# in sheet to and automatically
look for the product name from sheet 2 and fill it in. I tried a few "IF"
formulas, but w/out luck. Thanks for any help...
--
Nicki Taylor