+ Reply to Thread
Results 1 to 3 of 3

Pulling data from a column based on if it matches data if another column

  1. #1
    Registered User
    Join Date
    04-22-2016
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    23

    Pulling data from a column based on if it matches data if another column

    Good day,

    As per the attachment i require a formula that would pull data from 1 column (Lender daily billing) based on if it has data in the "Sec lending detail" column.

    The Lender daily billing column only has the share name and fee value whereas the Sec lending detail column has the portfolio , share , valuation and %

    The Fee Split column needs to detect which shares has fees and return the Portfolio/Share/Valuation/%.

    I've tried a variation and combination of INDEX/MATCH and IF formulas but nothing seems to work correctly.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Pulling data from a column based on if it matches data if another column

    using your sample file - mindful of limiting repetitive calculations pending size of your real data:

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


    Note: in your sample you will only get 2 rows returned for ABB (AA & DD), if you modify the other values, with above formulae in place, the relevant data will be returned.

  3. #3
    Registered User
    Join Date
    04-22-2016
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    23

    Re: Pulling data from a column based on if it matches data if another column

    Thank you! this works

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to auto-populate based on if one column matches data from another table
    By joshley2010 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2014, 11:15 AM
  2. Pulling rows of data based on criteria in one column
    By Ezekedes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2013, 10:54 AM
  3. [SOLVED] Pulling Data to separate sheets based on one column
    By joliver in forum Excel General
    Replies: 10
    Last Post: 10-04-2013, 05:14 PM
  4. Really easy task - automatically entering data based upon matches in a specific column
    By isthisthewaywego in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2013, 09:00 AM
  5. Pulling Data based on Column and Row names
    By Ryguy786 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-02-2013, 03:14 PM
  6. Replies: 1
    Last Post: 10-01-2012, 12:29 PM
  7. Replies: 5
    Last Post: 06-01-2011, 01:19 PM

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