Results 1 to 5 of 5

Multiple criteria matching for VLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple criteria matching for VLOOKUP

    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
    Attached Files Attached Files
    Last edited by utpalsekhar; 09-10-2012 at 05:16 AM. Reason: Upload sample file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1