Formula INDEX/MATCH

M

MadMax

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
 
Top