I have two diffrent sheets. One sheets has tens thausand lines with barcode value,description and quantity of product. another one has 2100 lines with just barcode of products .I want to match up barcode to barcode and get everything information that needed foe 2100 lines from the 10,000 lines.Please help me
Looks like you are in need of the VLOOKUP formula.
1: the cell/value you want to lookup. The barcode from sheet2
2: the matrix you want to look in. All the data from sheet1
3: the column you want to retrieve info from. For description 2, for quantity 3.
Select the matrix in the formula and hit F4 to make the reference absolute, do this for easy dragging.
Please post back if you get stuck (or to say thank you).