+ Reply to Thread
Results 1 to 3 of 3

Lookup key words in bank statement description

  1. #1
    Registered User
    Join Date
    10-08-2019
    Location
    Round Rock, Texas
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    1

    Lookup key words in bank statement description

    I would like to lookup key words in my bank statement descriptions in order to categorize the transaction.

    Here is an example of the Descriptions I will search in (Cell C2)

    BURGER KING #9905 08/31 PURCHASE MARLBOROUGH MA
    THE OLIVE GARD00016261 08/31 PURCHASE MARLBOROUGH MA
    BIG Y 29 HOLDE 09/02 PURCHASE HOLDEN MA

    Will be using the below table to search for the first field (Cell $I$2) in order to return the second field (Cell $J$2)
    Burger King Fastfood
    Olive Dining
    Big Y Groceries


    I am using below formula now
    =(IF(ISNUMBER(SEARCH($I$2,C2)),$J$2,IF(ISNUMBER(SEARCH($I$3,C2)),$J$3,IF(ISNUMBER(SEARCH($I$4,C2)),$J$4,IF(ISNUMBER(SEARCH($I$4,C2)),$J$4))))

    But this list is getting way to big.
    Is there a better way to create a lookup table which I can expand easier?

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,244

    Re: Lookup key words in bank statement description

    Try upload your file and example of your requirement, click on Go Advanced" button then scrolling down to find "Manage Attachments" text button to attach the file



    regards

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Lookup key words in bank statement description

    Hi. use this:

    =IFERROR(LOOKUP(1000,SEARCH($I$2:$I$4,C2),$J$2:$J$4),"")
    Attached Files Attached Files
    Glenn



+ 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. Running Bank Statement
    By spencerellis90 in forum Excel General
    Replies: 2
    Last Post: 07-19-2018, 08:18 AM
  2. Bank statement to excel
    By Berzins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2018, 01:50 PM
  3. bank statement template
    By kisanvikas2015 in forum Excel General
    Replies: 1
    Last Post: 06-29-2015, 12:07 PM
  4. [SOLVED] Excel 2007 : Find bank balance in bank statement
    By Baldev Kumar in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:58 PM
  5. Bank Statement/Budgets
    By austronymous in forum Excel General
    Replies: 0
    Last Post: 09-18-2011, 04:06 AM
  6. Converting Numbers to description in words
    By vvraj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-07-2006, 05:08 AM
  7. Simple Bank Statement
    By zym1ne in forum Excel General
    Replies: 0
    Last Post: 02-19-2005, 01:59 PM

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