Results 1 to 3 of 3

match data from 2 columns and then return value from a 3rd one

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2008
    Location
    Germany
    Posts
    16

    match data from 2 columns and then return value from a 3rd one

    hello,

    1. i am comparing text
    2. i have >100 countries, and with vlookup i have to type every single one, and this is what i want to escape (mb i need to refer to an array, or string, or no idea)
    3. mb a solution could be sth with index, or match, i just tried it, copying some similar formula from www, but it didn't match the countries, and return the value respective for that country.

    E.g. I have China in col1 (1st file), #employees 10 in col2 (1st file), and China in Col 1 in 2nd file. So, a formula should match China & China from both files, and return 10 as number of employees.

    If you see a solution, pls. let me know,

    thx a lot...
    Last edited by excel_try; 10-11-2008 at 03:59 PM.

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