+ Reply to Thread
Results 1 to 2 of 2

Assistance with a Lookup formula

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    1

    Assistance with a Lookup formula

    Hello - I am brand new to the forum and do not have significant excel experience. So any help is greatly appreciated!

    On a monthly basis I download my credit card and bank activity into excel. I then assign a number to each payee and the SUMIFS these transactions by date and # to my budget. Is there a way to build a table of payees and identify each payee with a number (ex. Giant Eagle 1, Best Buy 2) and produce a formula to look at this table of payees and if my credit card transaction contains that value then it would assign a #1 or #2 next to it? I have attached a simple example to help illustrate my question. Thank you. Example Calculation.xlsx

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Assistance with a Lookup formula

    welcome to the forum, TLake. try:
    =IFERROR(LOOKUP(2^15,SEARCH($L$9:$L$14,F8),$M$9:$M$14),"")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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. Lookup Match assistance
    By wadafruck in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2012, 02:59 PM
  2. [SOLVED] Lookup function assistance
    By LeapingLizard in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2012, 12:04 PM
  3. V Lookup assistance Needed
    By jdk789 in forum Excel General
    Replies: 5
    Last Post: 09-05-2012, 04:47 AM
  4. Sheet Lookup Assistance.
    By elmerg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2008, 11:59 PM
  5. [SOLVED] Lookup Assistance
    By Tiffany in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2006, 05:25 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