+ Reply to Thread
Results 1 to 5 of 5

Need formula to find matches, then populate other cells

  1. 09-04-2012, 11:03 PM #1
    damobilebrood
    damobilebrood is offline
    Registered User
    Join Date
    09-04-2012
    Location
    StL
    MS-Off Ver
    Office 2016
    Posts
    24

    Need formula to find matches, then populate other cells

    Hello All,
    I'm working with a master list of several thousand book titles with assigned genres and individual ID#'s. For specific orders that only consist of a few hundred of the titles, I'm trying to find the title in the master list then populate another cell with the appropriate genre title.

    Basically, if a title in Column E matches a title in the master list (Column B) I want it to grab the Genre title for that book from Column C and copy it to Column F.
    I'm using Excel 2010.

    Thanks, in advance, for any assistance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-04-2012, 11:09 PM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Need formula to find matches, then populate other cells

    Maybe this

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

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 09-04-2012, 11:11 PM #3
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Need formula to find matches, then populate other cells

    use index/match

    genre.xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  4. 09-05-2012, 08:31 AM #4
    damobilebrood
    damobilebrood is offline
    Registered User
    Join Date
    09-04-2012
    Location
    StL
    MS-Off Ver
    Office 2016
    Posts
    24

    Re: Need formula to find matches, then populate other cells

    Nevermind please disregard...worked like a charm. Thank you.
    Last edited by damobilebrood; 09-05-2012 at 08:38 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  5. 09-05-2012, 08:38 AM #5
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Need formula to find matches, then populate other cells

    In the Match function after the last comma needs to be a 0. 0 = ExactMatch


    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)

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