Posted to microsoft.public.excel.misc
|
|
oops... Getting product name from other sheet
Thanks!
--
Nicki Taylor
"Dave Peterson" wrote:
=vlookup() looks like it would work ok.
=if(a1="","",vlookup(a1,sheet2!a:b,2,false))
You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html
NTaylor wrote:
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
--
Dave Peterson
|