Forum Discussion

Copper Contributor

Feb 19, 2019

Merging Datasets

Dear Experts Please can you assist. I have column A and B in workbook 1 and column C in workbook 2. Column A and C contains some material numbers that match. I have to compare these two columns a...

excel

Man Fai Chan

Iron Contributor

Feb 19, 2019

You may consider the formula "vlookup" to do the things.

Since it is referring to another workbook, I suggest to copy and paste with values after getting the necessary data.

Jans_1194
Copper Contributor
Feb 19, 2019
Hi

Thank you for your response. Its much appreciated. A second question that I have is regarding comparison of data in two columns. I need to find numbers in column B that match the numbers in column A. Where column B does not have a matching number in column A, column B cells must shift down and leave blanks cells up to the next matching number in A?
Man Fai Chan wrote:
You may consider the formula "vlookup" to do the things.

Since it is referring to another workbook, I suggest to copy and paste with values after getting the necessary data.
- Man Fai Chan
  Iron Contributor
  Feb 19, 2019
  Sorry... I don't understand your question. Would you please attach a sample file with explanation to demonstrate the input you have and the output you want?