How do i assign value to 3 cells =E41, =H41, = B41 by typing 41

[Cells]

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

 

[CLR]

You would need VBA code for that........are you up for that? If so, explain
what values you want put in those cells when you type 41 in your key cell,
and which cell is to be the key cell.......and any other conditions you can
think of........someone will help.....

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

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)

 

[Cells]

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]

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.