So, how come you don't also make the column dependant on another cell, say
J3, where the formula becomes:

=INDEX(A1:H200,J2,J3)

Then you control column and row from reference cells outside the formula
itself.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Cells" wrote in message
...
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