# Assistance with a Lookup formula

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. ## 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),"")

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

#### 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