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
Software