Hi,
I am trying to get a workaround for an issue, which will help me to save lot of time working on huge number of records. I have a worksheet having
Column a (Product ID), Column b (Product Price), Column c(Sale Value)
I need to put another column d, which will be the name of product matching to product ID, there will be several repetition across the sheet on monthly basis across many worksheets. How do I add product name relating to product ID?
For e.g.
ID Price Sales Product
171a $12 $11 ItemA
171a $12 $11 ItemA
171a $12 $11 ItemA
171b $12 $11 ItemB
171b $12 $11 ItemB
every time I have to paste the product name w.r.t to the ID
Thanks in advance for any help
Bookmarks