Hi!
I have 2 files,
One contans Item, BatchNo, Quantity, etc. and the Second one have Item, BatchNo, Price, etc..
Now I want to put the price from the second file corresponding to Items batchwise. Sample file is attached.
File 1
Item# Description BATCH TOTAL QUANTITY Price Total Price
BL11-1204G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106017020 3734 Want to put price here
BL11-1204G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106010132 1500
BL11-1206G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106017030 3151
BL11-1208G 3/8" dia. Bul-Lockbolt Pin Zinc Plated BW106111072 500
BL11-1208G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106119031 1498
BL11-1210G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106115062 6000
BL11-1210G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106010132 3000
File 2
Item# Description BATCH Price
BL11-1204G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106017020 113.40
BL11-1204G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106010132 113.10
BL11-1206G 3/8" Dia. Bul-Lockbolt Pin Zinc Plated 106017030 170.20
BL11-1208G 3/8" dia. Bul-Lockbolt Pin Zinc Plated BW106111072 1007.00
BL11-1208G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106119031 1007.20
BL11-1210G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106115062 6000.00
BL11-1210G 3/8" dia. Bul-Lockbolt Pin Zinc Plated 106010132 6003.00
I tried VLOOKUP but could not found any solution.
Someone must know and will help me to solve the problem please.
Regards
Utpalsekhar
Bookmarks