+ Reply to Thread
Results 1 to 4 of 4

Very large list of codes that need crosswalked to identify category code. See attached

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Oklahoma
    MS-Off Ver
    MS Office Professional Plus 2010
    Posts
    5

    Very large list of codes that need crosswalked to identify category code. See attached

    I have a list of over 500 codes that I need to cross reference into approximately 25 coded categories. I have attached a file. If the value in A12 through A24 equals the value in A3 through A7 then insert the corresponding value from column B in column D12 through D24. I appreciate any help provided. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Very large list of codes that need crosswalked to identify category code. See attache

    try this in D12 and copy down

    =VLOOKUP(A12,$A$3:$B$7,2,0)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    10-26-2014
    Location
    Oklahoma
    MS-Off Ver
    MS Office Professional Plus 2010
    Posts
    5

    Re: Very large list of codes that need crosswalked to identify category code. See attache

    It worked. Thank you so much.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Very large list of codes that need crosswalked to identify category code. See attache

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

+ 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. Translating City Codes to Names (example attached)
    By cmf0106 in forum Excel General
    Replies: 13
    Last Post: 01-30-2014, 02:07 PM
  2. Macro codes for sending the one sheet attached through outlook
    By Ram Behera in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2013, 10:42 AM
  3. Macro codes for sending the one sheet attached through outlook
    By Ram Behera in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-27-2013, 10:42 AM
  4. [SOLVED] need formula to count number of cells that contain any of a LARGE list of zip codes
    By Security in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-14-2012, 10:37 AM
  5. How to identify the top 3 for each category
    By Rituraj in forum Excel General
    Replies: 3
    Last Post: 07-19-2010, 12:27 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