Using that how would I reference a cell in another worksheet in the same
document?

Thanks,

Joe B

"Dave Peterson" wrote:

Another one:

=index(C:C,a1)



WFBJoeB wrote:

I have a value in a cell. I want to get the value in another cell based on
this value. Say that the value in the first cell (A1) is 25. The cell I want
is in column C in this case it would be C25. How do I specify that 25 is a
row reference? This is EXACTLY what I want to do. Not some other type of
lookup, EXACTLY this.

Thanks,

Joe B

--

Dave Peterson