Thanks that helped

I also tried to use the Index() function and it did the job to
=INDEX(A1:H200,J2,2) Fills the Cell with data in B41 where J2 = 41

"Ragdyer" wrote:

Are you looking to display the data that's in cell E41 into another cell?

Say E41 contains 100,
E42 - 200
E43 - 300


Say A1 contains:
=E41
And displays that 100.

Do you want to change what's in A1, depending on the "row value" in another
cell, say B1?
Where B1 = 42, then A1 will display 200?

If that's the case, then the formula in A1 could be:

=INDIRECT("E"&B1)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks