Find same value

[cercle92]

Hi,

I have a problem with excel.
In colom A I have the ISIN Code of the mutual funds, and in colom B I have the type of funds.
In colom C I have again the ISIN codes but now multiple times the same code + in an different order.
Is there a function to compare the isin of colom A with the isins of colom D, and if the ISIN's are similar then in a new colom D there should be the same text as in colom C.
I know it's a bit confusing, but I've put the excelfile in attachment

testje.xlsx

[Fotis1991]

Hi

Please Login or Register  to view this content.

??

[cercle92]

No, because then I get the same value as in colom B. For example: A2:BE0026480963 B2:pensioenspaarfondsen; and now I would like to have for al the codes BE0026480963 in colom C, at the same row in colom D: pensioenspaarfonds. So these values have to be the same.

[cercle92]

Anyone who can help me?

[Fotis1991]

Type some expected results in your eaxample sheet explaining why you expect these and upload the sample again pls.

[cbatrody]

Please enter the following formula in cell D2. Hope this works..

=VLOOKUP(C2,A:B,2,0)

[cercle92]

Hi,

That worked!
Thanks a lot