+ Reply to Thread
Results 1 to 2 of 2

2 Vlookup Criteria

  1. #1
    Registered User
    Join Date
    01-11-2012
    Location
    india
    MS-Off Ver
    MS office 2010
    Posts
    16

    2 Vlookup Criteria

    I have to make a customer schedule forecast sheet. i record the customer demand every week with different different part no and store them in central database fie.

    i have to use 2 vlook criteria one - part no (C4) and second is date of Call off (D4) and then get the future demand Column E to Y.

    Vlook is required in F5 and F10 in "Stock overview sheet" . Drop Down is available in D5 and D10 .

    Customer Schedule working.xlsx

    please guide me.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 2 Vlookup Criteria

    Try in F5

    =INDEX('Database of Call off'!$E$5:$BE$12,MATCH(1,INDEX(('Database of Call off'!$C$5:$C$12=D6)*('Database of Call off'!$D$5:$D$12=D5),0),0),MATCH(F$4,'Database of Call off'!$E$4:$BE$4,0))


    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 02-17-2019, 05:43 PM
  2. [SOLVED] Vlookup with 2 criteria?
    By guitarguy1685 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2018, 12:06 PM
  3. Vlookup with 2 criteria help
    By YuriyBaron in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2018, 04:42 PM
  4. Large multi criteria / Vlookup/Choose Multi criteria
    By deanusa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2014, 01:48 AM
  5. vlookup with two criteria
    By amartino44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-11-2013, 11:39 AM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. VLOOKUP with 2 criteria
    By pelikaan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2013, 06:39 AM

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