vLOOKUP table help!

[ultimaterevenge]

Hi,

I am trying to make a database with a search function however the search function I am using is not doing what I need to do. This is why I have come here for some help.

Ok this is the problem..

Here I am searching a name as shown in the picture below;
\1

However in the database I have two versions of this person/player as shown below;
\1

So what im getting too is how would i bring up both versions up in the table?

Thanks in advance..

File down below;

[ultimaterevenge]

[Fotis1991]

hurry?

[ultimaterevenge]

hurry?

What do you mean?

[Fotis1991]

I just saw that you bump, 10 minutes after your first post and asked if you are hurry.

I suggest you to upload a small sample workbook. Not pictures. No one can work on picture.

[ultimaterevenge]

I just saw that you bump, 10 minutes after your first post and asked if you are hurry.

I suggest you to upload a small sample workbook. Not pictures. No one can work on picture.

Ok! the file is at the bottom now..

[Fotis1991]

In C11, put this Array formula(Control+Shift+Enter) Not just Enter.

cOPY DOWN AND ACROSS.

=IFERROR(INDEX(C$23:C$29,SMALL(IF($C$23:$C$29=$B$9,ROW(C$23:C$29)-22),ROW(C1))),"")

[ultimaterevenge]

In C11, put this Array formula(Control+Shift+Enter) Not just Enter.

cOPY DOWN AND ACROSS.

=IFERROR(INDEX(C$23:C$29,SMALL(IF($C$23:$C$29=$B$9,ROW(C$23:C$29)-22),ROW(C1))),"")

Thankyou so much!

[Fotis1991]

You are welcome!

Thanks for the reb*.