Closed Thread
Results 1 to 2 of 2

Pulling single cell from multiple possible columns using multiple criteria columns

  1. #1
    Registered User
    Join Date
    07-28-2019
    Location
    Atlanta, United States
    MS-Off Ver
    Excel 2016
    Posts
    15

    Pulling single cell from multiple possible columns using multiple criteria columns

    Hi,

    It's pretty straightforward from the attachment, but I'm trying to use criteria in cells C14 and C15 to populate C17. Cell C15 criteria will be found in columns D, F, and/or G; cell C14 criteria will be found in column B; I'm trying to use those to pull info from columns C, E, or G.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Pulling single cell from multiple possible columns using multiple criteria columns

    You were asked to update the title in your original thread. Please go back there and do so. Thanks.

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...a-columns.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 01-27-2017, 12:23 PM
  2. Replies: 9
    Last Post: 12-15-2013, 10:05 PM
  3. [SOLVED] UDF for sum of multiple criteria in multiple columns and single criteria in multiple colum
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-22-2013, 04:26 AM
  4. Splitting multiple entries in single cell into multiple columns
    By David_Mitchell in forum Excel General
    Replies: 12
    Last Post: 01-24-2013, 06:57 AM
  5. Creating multiple rown in single cell from multiple columns
    By Jonny_Ringo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-30-2008, 05:13 AM
  6. [SOLVED] Sum Count of Single Criteria in Multiple Non-Adjacent columns
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] SUMIF with multiple criteria for multiple columns to sum a single
    By SavageMind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 11:05 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