excel problem: According to a cell value to determine the values of the latter cells.
[Users questions | Browse:58 | Favorites]
Users questions: For example cell A1 allowed values are: 1,2,3,4,5. Cell B2 to allow the value of: A, B, C, D, E. When the value of cell A1 1, A2 should be the value of cell A; Similarly, the value of cell A1 Dangdang 2,3,4,5. When, A2 cell values should be For the B, C, D, E. How to set a function in cell A2?
Experts answer: can also enter the formula in A2: 1, "= HLOOKUP (A1, {1,2,3,4,5;" A "," B "," C "," D "," E "}, 2, ). " 2, "= IF ( A1=1, A ,IF(A1=2, B ,IF(A1=3, C ,IF(A1=4, D ,IF(A1=5, E , )))))
Experts answer: can also enter the formula in A2: 1, "= HLOOKUP (A1, {1,2,3,4,5;" A "," B "," C "," D "," E "}, 2, ). " 2, "= IF ( A1=1, A ,IF(A1=2, B ,IF(A1=3, C ,IF(A1=4, D ,IF(A1=5, E , )))))
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.