Results 1 to 6 of 6

Vlookup. IF a word from a list is in the string of a cell

Threaded View

  1. 03-22-2022, 06:10 PM #1
    bakedziti
    bakedziti is offline
    Registered User
    Join Date
    04-14-2015
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    29

    Vlookup. IF a word from a list is in the string of a cell

    I'm trying to make an easier way to categorize my spending in excel. You know how the bank describes a purchase as random things like "MERCHANT PAYMENT CITY FRESH MARKE - 5ON 010622 FROM CARD#: XXXXXXXXXXXX464X" and "MERCHANT PAYMENT - JEWEL OSCO ON 011022 FROM CARD#: XXXXXXXXXXXX464X"?

    So I want to have a list that says IF the string in cell ?? contains "JEWEL", it should return a string of "Groceries". And if it contains "CITY FRESH", it should be "Bakery". Etc.

    I uploaded an example to https://docs.google.com/spreadsheets...it?usp=sharing.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If a cell contains a specific word, return pre defined string for that word.
    By slamont in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-23-2022, 01:19 PM
  2. [SOLVED] Find a Word in a Text String From a List
    By thenewkidd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2022, 02:13 PM
  3. Use VLOOKUP when your lookup_value is a multi-word string
    By amarkert22 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-04-2018, 10:14 PM
  4. [SOLVED] Extract a word starts with a list of characters from a string
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-03-2016, 09:18 AM
  5. [SOLVED] Check if a string of text contains a word from a list, and specify which word that it is.
    By albanhac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2015, 07:35 AM
  6. Search a text string to see if it contains a word from a defined list, return that word
    By RCdude in forum Excel General
    Replies: 2
    Last Post: 08-05-2013, 04:45 PM
  7. Word List and Count from a string
    By Patchworks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2008, 02:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1