Formula INDEX/MATCH
 

Thanks after all to all users that can help and others too.

Sorry about my English.

The question that I want put is:

on the sheet1 i have an entry (i must type) numbers ex:
1..2..3..4...etc that i want match with names placed in two columns on
Sheet 2 like this: columns A with 1,2,3,4,... and columns B with
Jones, Peter, MadMax,....

on sheet 1 i want type 1 and with this formula he put Jones


any suggestion, thxs in advance

Formula INDEX/MATCH
 

=VLOOKUP(A1,Sheet2!A1:B100,2,0)


"MadMax" wrote:

Thanks after all to all users that can help and others too.

Sorry about my English.

The question that I want put is:

on the sheet1 i have an entry (i must type) numbers ex:
1..2..3..4...etc that i want match with names placed in two columns on
Sheet 2 like this: columns A with 1,2,3,4,... and columns B with
Jones, Peter, MadMax,....

on sheet 1 i want type 1 and with this formula he put Jones


any suggestion, thxs in advance