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:
This will give us the needed result in Column D. Yay!!
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!!
No comments:
Post a Comment