B
BobS
I have a large spreadsheet which is not a table or database (lot of blank
lines). As an example of my problem, in row 500, column F I may have a
formula such as =F200. In column C of row 500 I would like to pull the data
from column A of row 200. I need the formula in C500 to recognize the
reference from F500 and pull the associated info from column A.
lines). As an example of my problem, in row 500, column F I may have a
formula such as =F200. In column C of row 500 I would like to pull the data
from column A of row 200. I need the formula in C500 to recognize the
reference from F500 and pull the associated info from column A.