Copy cell to another as a comment
=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?
|