+ Reply to Thread
Results 1 to 2 of 2

Extract Values From One Column Based on Two Criteria From Two Other Columns

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Rogers
    MS-Off Ver
    Excel 2007
    Posts
    46

    Extract Values From One Column Based on Two Criteria From Two Other Columns

    Thanks to this forum, I've solved one question but leave it to me to go another step further. In the attached, sheet 2 has a formula that pulls the Item (column B) from Sheet 1 based on Instocks (column F) being less than the value in N2. Would it be possible to add a second criteria to the formula in sheet 2? In short, can I pull the item from column B of sheet 1 into sheet 2, where in sheet 1, column F values are less than N2 AND where column G values are greater than O2?

    I'd love to just vlookup the fill rate value and then filter it down, I know at some point I will be asked to weed it down a bit via a formula instead. Many thanks in advance!!!
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Extract Values From One Column Based on Two Criteria From Two Other Columns

    HI rlh06,

    Try using below formula:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    see attached:- Formula Needed2.xlsx


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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