How to Match Two Columns Where the First Column Contains Many Empty Cells

Hi everyone,

I have three columns. One is a whole list of codes, but it has lots of empty cells in it. E.g.:


2168-269
2168-197




2169-003
2169-227




2172-215
2172-001


Then the second column has all the same codes but with no empty cells. Then the third column has lots of data relating to the second column.

I need to somehow match the second and third columns to the first column so they also have the empty cells in them. Is this possible?

Many thanks in advance for any help you can give.

Chris

Hi there,

Thank you for your response. I will PM a file now.

Many thanks,

Chris