Closed Thread
Results 1 to 2 of 2

VLOOKUP problem (attached file)

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Rotterdam
    MS-Off Ver
    Excel 2003
    Posts
    7

    VLOOKUP problem (attached file)

    Dear,

    I have trouble with an excel datafile. I am trying to use a VLOOKUP function but it simply does not work. I have attached the file so I will walk you through my file.
    In the 'Main' sheet I am trying to find the correct CIK (Column F) codes by using the Identifier (Column E). I do this by using a VLOOKUP from the sheet 'Uitgebreid'. In the sheet 'Uitgebreid' the identifier is mentioned in column B and the CIK code in Column D. As you can see in the example that I gave a red border it only finds the "87588" number in the 'Main' sheet but as you can see from the red highlited part in 'Uitgebreid' this company probably changed its name in 2001 and their CIK code changed (Identifier stayed the same).
    My question:
    - How do I get these both values "87588" and "1135431" in the 'main' sheet?

    Thanks in advance.

    Regards,

    Daan
    Attached Files Attached Files

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: VLOOKUP problem (attached file)

    thread closed as

    Posted in Comercial Services section
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 11-09-2012, 11:08 AM
  2. Conditional Array & VLOOKUP: Example file attached
    By David Brown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2010, 09:43 AM
  3. Conditional Format Paste Problem - File Attached
    By Joe B in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2009, 08:54 AM
  4. Replies: 3
    Last Post: 10-02-2008, 09:27 AM
  5. vlookup function-what function to use please see the attached file
    By kcdelong in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2008, 06:18 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