Problem with If-else function

[Cameraman84]

Hello

I have the following problem...

I have a Page with all the Names and Surnames.
In other page I "call" the name and Surname by the number with if else function. (e.g. if the No is 1, Name 1 Surname 1) (if the No is 2, Name 2 Surname 2)
BUT....when the name is the same, the function "call" the first name and surname who find first at the list. Why the Function "read" the name? In the function i say to read only the Number...

What i must change to the function?

The Function for the NAMES is:
=IF(A3=NAMES!A$3;NAMES!B3;
IF(A3=NAMES!A$4;NAMES!B4;
IF(A3=NAMES!A$8;NAMES!B8;
IF(A3=NAMES!A$9;NAMES!B9;
IF(A3=NAMES!A$10;NAMES!B10;
IF(A3=NAMES!A$11;NAMES!B11;
IF(A3=NAMES!A$12;NAMES!B12;
IF(A3=NAMES!A$13;NAMES!B13;
IF(A3=NAMES!A$14;NAMES!B14;
IF(A3=NAMES!A$15;NAMES!B15;
IF(A3=NAMES!A$16;NAMES!B16;
IF(A3=NAMES!A$17;NAMES!B17;
IF(A3=NAMES!A$18;NAMES!B18;
IF(A3=NAMES!A$19;NAMES!B19;
IF(A3=NAMES!A$20;NAMES!B20;
IF(A3=NAMES!A$21;NAMES!B21;
IF(A3=NAMES!A$22;NAMES!B22;
IF(A3=NAMES!A$23;NAMES!B23;
IF(A3=NAMES!A$24;NAMES!B24;
IF(A3=NAMES!A$25;NAMES!B25;
IF(A3=NAMES!A$26;NAMES!B26;
IF(A3=NAMES!A$27;NAMES!B27;
IF(A3=NAMES!A$28;NAMES!B28;
IF(A3=NAMES!A$29;NAMES!B29;
IF(A3=NAMES!A$30;NAMES!B30;
IF(A3=NAMES!A$31;NAMES!B31;
IF(A3=NAMES!A$32;NAMES!B32;
IF(A3=NAMES!A$33;NAMES!B33;
IF(A3=NAMES!A$34;NAMES!B34;
IF(A3=NAMES!A$35;NAMES!B35;
IF(A3=NAMES!A$36;NAMES!B36;
IF(A3=NAMES!A$37;NAMES!B37;
IF(A3=NAMES!A$38;NAMES!B38;
IF(A3=NAMES!A$39;NAMES!B39;
IF(A3=NAMES!A$40;NAMES!B40;
IF(A3=NAMES!A$41;NAMES!B41;
IF(A3=NAMES!A$42;NAMES!B42;
IF(A3=NAMES!A$43;NAMES!B43;
IF(A3=NAMES!A$44;NAMES!B44;
IF(A3=NAMES!A$45;NAMES!B45;
" "
))))))))))))))))))))))))))))))))))))))))

The Function for the SURNAMES is:
=IF(B3=NAMES!B$3;NAMES!C3;
IF(B3=NAMES!B$4;NAMES!C4;
IF(B3=NAMES!B$8;NAMES!C8;
IF(B3=NAMES!B$9;NAMES!C9;
IF(B3=NAMES!B$10;NAMES!C10;
IF(B3=NAMES!B$11;NAMES!C11;
IF(B3=NAMES!B$12;NAMES!C12;
IF(B3=NAMES!B$13;NAMES!C13;
IF(B3=NAMES!B$14;NAMES!C14;
IF(B3=NAMES!B$15;NAMES!C15;
IF(B3=NAMES!B$16;NAMES!C16;
IF(B3=NAMES!B$17;NAMES!C17;
IF(B3=NAMES!B$18;NAMES!C18;
IF(B3=NAMES!B$19;NAMES!C19;
IF(B3=NAMES!B$20;NAMES!C20;
IF(B3=NAMES!B$21;NAMES!C21;
IF(B3=NAMES!B$22;NAMES!C22;
IF(B3=NAMES!B$23;NAMES!C23;
IF(B3=NAMES!B$24;NAMES!C24;
IF(B3=NAMES!B$25;NAMES!C25;
IF(B3=NAMES!B$26;NAMES!C26;
IF(B3=NAMES!B$27;NAMES!C27;
IF(B3=NAMES!B$28;NAMES!C28;
IF(B3=NAMES!B$29;NAMES!C29;
IF(B3=NAMES!B$30;NAMES!C30;
IF(B3=NAMES!B$31;NAMES!C31;
IF(B3=NAMES!B$32;NAMES!C32;
IF(B3=NAMES!B$33;NAMES!C33;
IF(B3=NAMES!B$34;NAMES!C34;
IF(B3=NAMES!B$35;NAMES!C35;
IF(B3=NAMES!B$36;NAMES!C36;
IF(B3=NAMES!B$37;NAMES!C37;
IF(B3=NAMES!B$38;NAMES!C38;
IF(B3=NAMES!B$39;NAMES!C39;
IF(B3=NAMES!B$40;NAMES!C40;
IF(B3=NAMES!B$41;NAMES!C41;
IF(B3=NAMES!B$42;NAMES!C42;
IF(B3=NAMES!B$43;NAMES!C43;
IF(B3=NAMES!B$44;NAMES!C44;
IF(B3=NAMES!B$45;NAMES!C45;
" "
))))))))))))))))))))))))))))))))))))))))

Thanks for all
John K.

 

[Fluff]

Hi & welcome to MrExcel.
Your 2nd formula is looking at the First Name not the number, which is why you get the problem, it should be looking at A3, not B3

 

[Fluff]

However I would get rid of those nested If functions & use vlookup, like

=VLOOKUP(A3,Names!$A$3:$C$45,2,0)

and

=VLOOKUP(A3,Names!$A$3:$C$45,3,0)

 

[Cameraman84]

Hi & welcome to MrExcel.
Your 2nd formula is looking at the First Name not the number, which is why you get the problem, it should be looking at A3, not B3

Thanks a lot! with so many cells, my brain.... THANKS from Greece!

 

[Fluff]

You're welcome & thanks for the feedback.