Results 1 to 2 of 2

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

Threaded View

  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

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