Formula Help

[Kathleen_0422]

I have a spreadsheet that shows me the differences between 2 files. It tells me the:

A - Supplier 'Example "ABC"
B - File Name 'Example "ABC.xls"
C - Cell Address where values differ 'Example "$G$11"
D - Replacement Value 'Example " Obsolete"

What I would like to do is pull information from the original file Column E of the row number returned in Column C from the above sampling.

I inserted a column and by using a mid function can get to the row that is being referenced in Column C

I thought I could build a formula that would

Return the value that is in the Original File in column E of that row number.

I can sucessfully get it to the point of:

Selection.formula = "='[" & File1 & "]Inventory List'!E"

Can you tell me how to append the row number to my formula?

I will then copy the formula down to a dynamic set of rows on the Difference Report.

THANKS IN ADVANCE

 

[Kathleen_0422]

Cell Address Help Needed Please

I just realized that someone else has the same title