Copy cell values if cells match on two diff sheets

D

dan

I have a question, and I thank you ahead of time for any help.

Sheet1 has ColA with formula number, ColB has ID number of formula,
ColC has Description of the action using the formula. ColB is unique,
ColA is not. An example might be like this:

ColA ColB ColC
80 100 This fixed boxZA
80 101 This fixed Box ZB
80 102 This fixed Box z9
94 103 This was maintenance.
94 104 Server Maintenance

Sheet2 has a pivot chart, looking like this:
ColA ColB
Formula Number Count of Form#
80 3
94 2

I would like to add column C next to the pivot chart on Sheet2 with a
description. It would be like if a cell in Sheet1 colA matched a cell
in sheet2 colA, it would make sheet2 ColC = sheet1 colC where ColA
matched.

So if Sheet1 ColA had 80 and Sheet2 ColA had 80, Sheet2 would pull the
description from Sheet1 on the row with 80.

This can be done by formula or macro. I appreciate any help you can
give me, thank you!!

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top