Results 1 to 48 of 48

Need VLOOKUP for multiple criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-06-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2016
    Posts
    611

    Exclamation Need VLOOKUP for multiple criteria

    Dear experts,
    In the following work sheet (this has VB also running behind), I need the following;

    #01
    The cell U6 returns the value (start up days) as per the the table in "categories" sheet(S2 to P9).

    However, I need to combine another criteria to this using the table in categories sheet (R12 to S13). Accordingly, the resulted value in U6 should be changed. Selection criteria is in column I6 (RPT or NEW).

    #02

    The cell V6 should calculates the no of days the production run (example: in row 6>>> 7 days(days run) - from May 17 to May 24). Need a formula to handle this condition.


    Thanks in advance
    Anuruddha
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup multiple criteria returning multiple values
    By ykobure in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-16-2015, 07:28 AM
  2. [SOLVED] iserror and vlookup with multiple criteria from multiple tables along with concatenation.
    By marcusduton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2015, 02:16 AM
  3. Vlookup on multiple axis with multiple criteria
    By theLOLkid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-11-2015, 02:48 PM
  4. Vlookup (or index/match) with multiple criteria over multiple sheets
    By Groovicles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 01:56 PM
  5. 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
  6. Possible VLOOKUP multiple criteria & multiple worksheets
    By this2willpass in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2012, 08:23 AM
  7. Vlookup + multiple criteria + multiple data returned
    By stonesy in forum Excel General
    Replies: 6
    Last Post: 02-17-2010, 08:53 AM

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