Hi
Try using in INDIRECT function.
e.g..
A1=225
B1=A
C1=1

to extract the value in A1 using both B1 and C1 has your reference
then:
=INDIRECT(B1&C1)

or if you already know your column reference, "in this case A" then:
=INDIRECT("A"&C1)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=476792