+ Reply to Thread
Results 1 to 4 of 4

How to populate cells with data from another sheet based on an X in certain columns

  1. 09-18-2015, 10:18 AM #1
    WWasmer2
    WWasmer2 is offline
    Registered User
    Join Date
    09-16-2015
    Location
    Kansas City
    MS-Off Ver
    2013
    Posts
    2

    How to populate cells with data from another sheet based on an X in certain columns

    This is my first post so feel free to give me some pointers about the forum.

    Here's what im trying to accomplish, I have a sheet "Dealer Master" it has a list of all of my dealers along with the Rep assigned to them and Columns with manufatures we represent. There are X to mark if the dealer has an account with that manufature. I would like to populate the rest of the shees with the Dealer names of the companys that have an X in that column along with the rep assigned to the dealer. I'm trying it withe the "Primacoustic" sheet first since it has the least amount of dealers. I have tried INDEX, VLOOKUP, LOOKUP. All with no luck. Any ideas? BC Monthly Sales Tracker.xlsx
    Reply With QuoteRegister To Reply
  2. 09-18-2015, 10:37 AM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to populate cells with data from another sheet based on an X in certain columns

    Hi WWasmer2 and welcome to the forum

    Please see attache file with formulas.

    for Primacoustic:

    Enter formula in A4 and pull formula to column B and then down

    =IFERROR(INDEX('Dealer Master'!A:A,AGGREGATE(15,6,ROW('Dealer Master'!$F$4:$F$114)/(('Dealer Master'!$F$4:$F$114="x")),ROWS(A$4:A4))),"")

    For Whirlwind:

    =IFERROR(INDEX('Dealer Master'!A:A,AGGREGATE(15,6,ROW('Dealer Master'!$F$4:$F$114)/(('Dealer Master'!$G$4:$G$114="x")),ROWS(A$4:A4))),"")

    Enter formula in A4 and pull formula to column B and then down
    Attached Files Attached Files
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 09-18-2015, 10:41 AM #3
    WWasmer2
    WWasmer2 is offline
    Registered User
    Join Date
    09-16-2015
    Location
    Kansas City
    MS-Off Ver
    2013
    Posts
    2

    Re: How to populate cells with data from another sheet based on an X in certain columns

    You are the BEST. My Chiefs lost yesterday but this made my day much better!
    Reply With QuoteRegister To Reply
  4. 09-18-2015, 10:44 AM #4
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: How to populate cells with data from another sheet based on an X in certain columns

    You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
    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. macro to populate cells based on value on other sheet
    By swfarm in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2014, 03:03 PM
  2. [SOLVED] Populate data on another sheet based on dropdown criteria from the first sheet
    By ARod0726 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2013, 01:36 PM
  3. [SOLVED] Macro to Auto-populate cells and columns based off of a Number
    By Cansa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 05:59 PM
  4. Populate record with 20 columns data in master sheet every time data changes in one sheet
    By ashs22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 07:29 AM
  5. Populate 2 columns with data from a different two columns based on one cell's value
    By ChrisHowk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2012, 06:01 PM
  6. [SOLVED] Populate columns in one sheet based off of a few lists in a different sheet
    By jimadaly in forum Excel General
    Replies: 12
    Last Post: 05-11-2012, 03:09 PM
  7. Populate one sheet with data from a different sheet based on similar cells
    By DirtyTech in forum Excel General
    Replies: 4
    Last Post: 03-01-2012, 01:05 PM
  8. Auto-populate cells based on data from another sheet
    By tmartin1313 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2011, 12:15 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