This may be a super-easy question but I'm a relative beginner trying to find a quicker way to code credit card statements. I want to use a formula to autofill a column based on keywords in the cell to the left. For example if the credit card purchase is UBER TRIP X3HG8, I want Excel to see "Uber", which I would have in a table on the next sheet next to 55110, the Account Code for Ground Transportation, and fill it in.Here's what I have:Date | Description | Account Code | Amount_______________________________________________6/11/18 | UBER TRIP X3HG8 | (formula needed) | $25.00I'd have a full table on the next sheet with common words like Uber, Lyft, taxi, Airlines, Restaurant, Bar, Hotel, monthly subscriptions. etc. so that every month I just copy the new statement and I can auto-fill 90% of the statement.Any suggestions? Thanks in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
"VLOOKUP if cell contains" help
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Something like...
=VLOOKUP("*"&X2&"*",Table,3,0)
where X2 houses a look up value like uber or lyft, etc. The formula brings back a result value from the 3rd column of Table.
=VLOOKUP("*"&X2&"*",Table,3,0)
where X2 houses a look up value like uber or lyft, etc. The formula brings back a result value from the 3rd column of Table.
Upvote
0
Similar threads
- Question
- Question
- Question
