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
|