Formula INDEX/MATCH

  • Thread starter Thread starter MadMax
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with ISNA, INDEX, MATCH 2
With F1 value, look at A, if match or partial match return B 5
Excel help INDEX MATCH w/ division and subtraction 0
index, match in array setup question 1
trying to match text in 2 worksheets 1
vlookup or index for text on 2 worksheets 2
Index Match on Columns and Rows 0
Index and Match 3

Back
Top