Hello!

I have a spreadsheet with three different worksheets A, B, and C.

In worksheet A, I have a column of 10,000 cell coordinates (A1, H6, AB123...)
In worksheet B, I have the values that the references in worksheet A refer to.
In worksheet C, I have a column full of the following formula:
=REPLACE(B!L12,((LEN(B!L12)-2)),3," ")

I need the formula in C to go to worksheetA, look at the cell references(a1,b1...) and use those cell references in worksheet B.
That is, the value to be used as an input in the formula in worksheet C is in worksheet B. However, the coordinates of these inputs are in worksheet A.

Worksheet A
AC
--------
1 I L97
2 I L98
3 I J99
4 I J100
5 I J101
6 I J102


Worksheet B

J K L
----------------------------------------
97 I 15.01.06 -,- 101.8006/09
98 I 15.01.14 -,- 102.2006/09
99 I 15.01.10 -,- 105.6506/09
100 I 101.0006/09 -,- 20.10.07
101 I 102.0006/09 -,- 20.10.07
102 I 106.1506/09 -,- 04.01.11


Worksheet C
Formula

I can't put the references (in worksheetA) into the formula by hand because they are going to change. That's why I need some sort of an automated way. One restriction is I cannot change the place of data to a differnet worksheet.



TO SUMMARIZE:
The formula in worksheet C takes the values in Worksheet B(spread out in different cells) and formats those numbers. The places of these numbers are in Worksheet A(columnAC). So I need the formula to use the values in Worksheet A as an input reference for worksheetB and calculate the number in worksheet C. Tough to explain but I hope you got it. Thanks for any help.