G
Guest
What I would like to do is tell excel to link a certain cell =$A$1 style, but
use the contents of another cell to specify this. For example, if the value
of A1 was the number 3, I would like to link to =$B$3. So far, the only
think I have found to work is using an if statement to say IF(A1=3, =$B$3)
but this isn't practical for a spreadsheet with many many rows. Is there a
way to have excel fundamentally do a =$B$(A1) where it uses the value of A1
to determine which column in B to link to? It seems like there has to be a
way to do this if an if statement can do this for a limited data set.
use the contents of another cell to specify this. For example, if the value
of A1 was the number 3, I would like to link to =$B$3. So far, the only
think I have found to work is using an if statement to say IF(A1=3, =$B$3)
but this isn't practical for a spreadsheet with many many rows. Is there a
way to have excel fundamentally do a =$B$(A1) where it uses the value of A1
to determine which column in B to link to? It seems like there has to be a
way to do this if an if statement can do this for a limited data set.