=if(iserror(vlookup(a2,data!A1:b1000,2,0),"",(vloo kup(a2,data!A1:b1000,2,0))

assuming in a2 you have the code of the part, and on sheet data you have the
sizes and etc.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"rpick60" escreveu:

I import external data and I would like to take text in a cell and add
it to another cell as a comment.
I have a long list of part numbers and some have sizes. I would like
to take the sizes and add them as comments to the part numbers. Not
all part numbers have sizes so I only want the ones with data in the
cell.

Any Ideas?