VLOOKUP problem (with 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

Welcome to the forum

Pls take some minutes to read forum rules.

Also pls notice that if you post in Comercial Services section-like you did- we have to close your thread in the free forum.

So thread closed as

1)duplicated
2)Posted in Comercial Services section