+ Reply to Thread
Results 1 to 2 of 2

if then macro to find word and update another cell in row with an assigned number

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Charleston
    MS-Off Ver
    Excel 2007
    Posts
    1

    if then macro to find word and update another cell in row with an assigned number

    Hi
    I have searched all over for a macro to find a word in one cell and update a cell in another column and can't seem to find exactly what I am looking for to modify...
    I have a spreadsheet and need to look for liquor types in column A and then update column K with a corresponding code number for that liquor type.
    Ex-
    Find word in column A and put number in column K.
    Liquor, 1
    Rum,2
    Vodka, 3
    Brandy, 4
    Whiskey,5
    Tequila, 6
    Cognac, 7
    Amaretto, 8
    Scotch, 9
    Wine, 10
    Can someone help me with a macro?

    Thanks
    Doug

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: if then macro to find word and update another cell in row with an assigned number

    I think this can be achieved with a VLOOKUP formula. Unless I am missing something.

+ 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. [SOLVED] Word macro to find end of cell mark
    By velvasi in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2014, 08:26 AM
  2. [SOLVED] Macro to find a word and out a % in a cell when it finds it
    By mmurphy77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2013, 06:38 PM
  3. Need Ms Word Macro to update word content
    By shabeersa in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2013, 05:49 AM
  4. Replies: 8
    Last Post: 10-19-2012, 10:34 AM
  5. Assign a macro to automatically find the last assigned other macro
    By tperkins1973 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2012, 06:39 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