Dave,

Here's the final working version:

=IF(INDEX(data!A:A,$C$4) = $C$1,INDEX(data!D:D,$C$4),"")

Thanks again,

Joe B

"Dave Peterson" wrote:

Maybe...

=index('Other sheet name here'!x:x,a1)
or
=index(c:c,'other sheet name here'!a1)




WFBJoeB wrote:

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


--

Dave Peterson