I am not familiar to Indirect Function nor I could understand it fully from
the Help menu. Can you explain the syntax of this function: What do R50C,
row()-4 and false signify. Thanks.

"bj" wrote:

You can use the indirect() function
=indirect("[File1]Wks1!R50C"&(row()-4),false)
should work

"neeraj" wrote:

I am trying to use fill handle to copy a formula down a column from a row in
another workbook. The column is B9,B10,B11, .... and the row in a worksheet
say Wks1 of another file, say File 1 is E50, F50, G50,... The formula in B9
looked like =[File1]Wks1!$E$50. I use the fill handle to copy the formula
down the column in B10, B11 but what I got in all cells that is B10, B11 was
the same that is =[File1]Wks1!$E$50. I would have like to fill to
=[File1]Wks1!F50, =[File1]Wks1!G50. I then changed the cell reference from
the fixed cell reference in B9 to =[File1]Wks1!E$50. When the move the fill
handle down in my destination column, it doesn't change the cell reference
and it remains E$50. I have tried changing the formula in B9 to both $E50 and
to E50 but it changes it to E51, E52. How can I fill my column such that the
cells B10, B11,....derive their values from F50, G50,....