+ Reply to Thread
Results 1 to 2 of 2

Return 3 column values if criteria met

  1. 11-03-2021, 11:07 AM #1
    Daniel_ISS
    Daniel_ISS is offline
    Registered User
    Join Date
    10-03-2019
    Location
    Bolton, England
    MS-Off Ver
    365
    Posts
    27

    Return 3 column values if criteria met

    Hi,

    Please can someone help with this formula,

    I have highlighted in green what i'm trying to achieve and uploaded a sample workbook.



    Basically I need a formula that will return the first 3 columns of a table if the criteria is met example attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-03-2021, 11:24 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Return 3 column values if criteria met

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Return values into one column (below each other) based on criteria in another column
    By budgie in forum Excel General
    Replies: 2
    Last Post: 04-24-2019, 06:25 AM
  2. Need help nested if where based on criteria then return values from another column
    By Britniblock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2018, 05:07 PM
  3. Return All values matching criteria of Another Column
    By kmdavila in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2017, 10:51 AM
  4. Return values from column matching criteria VBA
    By ChipsSlave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2016, 12:44 PM
  5. Return unique values from one column with multiple criteria from another column
    By Excel Geek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2015, 11:40 PM
  6. Return column values based on criteria
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2014, 10:55 AM
  7. Return Values in of Cells in a Column where Two Other Values in Corr. Rows Match Criteria
    By samtp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2013, 12:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1