I'm still learning how to use MS Excel, so when you respond, please don't use a lot of technical terms I will have to look up the meanings to.
Ok. I know how to do this: when I put "1" in cell A1, I need data in cell G1 to appear in cell B1. This is a very simple formula in cell B1: =IF(A1=1,G1) Here is my problem though. In Column G, I have data from G1 to G100. "IF" formulas only allow up to seven "IF"s in a cell. For example:
=IF(A1=1,G1,IF(A1=2,G2,IF(A1=3,G3,IF(A1=4,G4,IF(A1=5,G5,IF(A1=6,G6,IF(A1=7,G7,IF(A1=8,G8))))))))
I need to go all the way to IF(A1=100,G100). The above example is the largest "IF" formula that it will allow me in one cell. How can I make it where if I put "57" in A1 then the data in G57 shows up in B1 or "79" in A1 results in B1 showing G79 data, etc, etc, etc. It would be 100 "IF"s in the formula, but Excel only allows seven. How else can I do it? Here is my e-mail, if you would like to respond by email. jninjacash31@yahoo.com. Thanks
2007-09-17 00:47:57 · 2 answers · asked by jninjacash31 3 in Computers & Internet ➔ Software
You need an Excel function called INDEX, which finds what is in the Nth cell of an array of cells.
Put this formula in B1:
=INDEX($G$1:$G$100, A1)
If A1 is 57, this will return what is in G57.
If you need more info, add more detail or e-mail.
Cheers.
.
2007-09-17 05:54:27 · answer #1 · answered by aladou 5 · 0⤊ 0⤋
Have a read of the Excel Help files under the If statement.
Look for the solution at:
2007-09-17 01:48:51 · answer #2 · answered by ELfaGeek 7 · 0⤊ 0⤋