Microsoft Excel: How do you make a list that can change it's content based on numbers in adjacent cells?

Question

I can't figure out how to get my idea to work in excel. If any of you are experts in excel I would appreciate some assistance. Thanks.

Answer 1

Have you tried using a "vlookup"? It's a formula that should be in the formula list. Or you could just use an equation such as "sum" or "average". It depends on what you are trying to do. Can you give some more information?

Answer 2

If the numbers you want to enter are between 1 and 29, you can use the function "Choose."

Here is an example: =CHOOSE(B2, "Jan", "Feb", "Mar")

I only filled in the first three months, but if you put 1 in B2, the cell with this formula will show "Jan", 2, "Feb", and so on.

Many people use this function to change the weekday function numeric result into the text representation of the day of the week, such as "Sun", etc.

Look up the function Choose in your Excel Help. There is more info there.

Answer 3

I will be glad to help
Although I can't understand you well.
You need the selection of list to be changed from the 2nd value to the third value if we changed 2 in other cell to 3
Is that what you need?
If yes or no, I will need you to mail me through Y! Answers the details and your e-mail to solve it, it needs some work to be done

Read my profile, I am the XLMan

Answer 4

that's illegitimate that you'll be able to be making a hydrogen bomb on your storage .......... Or at everywhere else for that topic. i'd answer your question yet I received't connect your villainous scheme. Please do not commence begging.

Answer 5

Create a function:
=Sum(A1:A6) will give you the sum of A1+A2+A3+A4+A5+A6