VLOOKUP / INDEX Problem

[MrRC]

Dear sirs,

I'm having some problems with an excel formula and i would like to hear your expert opinions on this
I'm using Excel 2007 and I have 2 Sheets:
Sheet1:
___A B C D E F
bla X X
ble X

Sheet2:
Name Letter
bla__ A
ble__ A
bla__ B

How can i make a formula to populate Sheet1 with an X the letters that it finds on the contact auto?

I'm using =IF(INDEX(Contactos!$CI2:$CI$2445;SMALL(IF(Contactos!$CE2=Contactos!$CE2:$CE$2445;ROW(Contactos!$CE2:$CE$2445)-MIN(ROW(Contactos!$CE2:$CE$2445))+1; ""); ROW($A$1)))=AP$1;"X";"") it works, but only finds the first item.. i'm going the wrong way

Thanks for your help

 

[T. Valko]

Ok, here it is..

http://cjoint.com/data3/3Fwkh3kvnVV.htm

Ok, I thnk this does it.

MrRC(1).xlsx 10kb

http://cjoint.com/?AFwqOVGWNVv

When you download that file it might get saved on your computer as a ZIP file.

If that happens you can open the file as a ZIP file in Excel 2007 and later. Or, you can simply rename the file with the Excel 2007 file extension .xlsx.

 

[MrRC]

Working perfectly!

Please send me your paypal id through pm i will glad to pay u a beer

Thanks a lot!

 

[T. Valko]

Working perfectly!

Please send me your paypal id through pm i will glad to pay u a beer

Thanks a lot!

Great!

I''m glad we finally got this straightened out.

Here, let's have a virtual beer:

 

[MrRC]

I insist, if you change your mind just pm me

Again thanks!