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
|