Results 1 to 12 of 12

Evaluate one cell against an array

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    Zurich, Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    15

    Evaluate one cell against an array

    I have two sets of information, on one hand I have telephone numbers and in the other set I have prefixes and countries. My goal is to tell to which country each number belongs:

    i.e.


    Numbers Prefix Country
    4476324125 44 UK
    3354326544 33 France
    9713425432 971 UAE
    9143253245 91 India
    1343543253 1 USA
    4432412412
    4924241214
    7431242424



    So I would need to add a column next to "Numbers" saying to which country each number belongs.

    My list has a few thousand numbers and a couple of hundred prefixes.
    I tried with some array formula, but cannot make it work. Any idea on how this can be done? It would be interesting not to use VB.

    Thanx!
    Last edited by tatoon; 10-29-2009 at 07:00 AM.

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