Results 1 to 3 of 3

Tricky Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    Vienna,Austria
    MS-Off Ver
    Excel 2007
    Posts
    6

    Tricky Vlookup

    Hi,

    I've been trying to find a efficient solution to the following problem.

    In column A there are several strings:

    A || B || C
    #Canada 2453 ||
    #Chinaabce ||
    #Wood 8673 ||
    #Carslkus ||


    In another table there are the some classifications,for example:
    A1 || B1 || C1
    Canada|| Country|| America
    Wood || Product|| Utility
    China || Country|| Asia
    Cars|| Product|| Lifestyle

    Now my problem is to get the classification of B1 and C1 into the original table (B and C), so that my table looks like:

    A || B || C
    #Canada 2453 || Country|| America
    #Chinaabce || Country|| Asia
    #Wood 8673 || Product ||Utility
    #Carslkus || Product|| Lifestyle


    Does anybody know a efficient way to do this?

    Thank you very much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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