Sharing some useful tips, solutions and notes for Geeks.

Monday, May 18, 2020

Match two columns in an excel

Sometime we might be needed two columns to match and take the third column values. Confused?
OK let me tell you a scenario.

Suppose i have three columns in an excel.

Column A: A list of 1000 SKUs
Column B: Barcodes associated with those SKUs
Column C: A list of 100 specific SKUs that I need the barcode for

So, I'm looking to search column A for a value that matches C and return the barcode from column B in a new column, say column D.

In such cases we can make use of below formulae:



=INDEX(B:B,MATCH(C1,A:A,0))



This will give us the needed result in Column D. Yay!!


1 comment:

High Technologies Solutions said...

High Technologies Solutions has conducted multiple Advanced Excel Corporate Training, VBA Macros Corporate Training batches in all over India. Further More Details Here-+91-9311002620 Or Visit Website- https://www.htsindia.com/Courses/Business-Analytics/adv-excel-training-course