Hope You all doing good .I New to Excel
. What I'm Looking for is to get a Cell Value from another sheet on the same work book. But the address of the cell cannot predict initially, It depends upon the value entering on the cell of first sheet. I explain my problem with an example I have two sheets sheet1
and sheet2
when user enter a value on one cell sheet1
(assume that is 12) then I need to get the value of A12
from sheet2
to any cell of sheet1
?.Is there a possible solution without VBA?. Please Help me?
Note :- this value 12
is an example it can 100
,5
, 200
or X
so what I would like to have is the value of cells A100
, A5
, A200
and AX
from sheet2
(ie, =Sheet2!A100
,=Sheet2!A5
, =Sheet2!A200
or =Sheet2!AX
)
On the above image when user enter a value 1
on cell C2
of sheet1
,I need to get Sheet2!1
on cell D2
of sheet1
what I have tried is that
=INDEX(Sheet1!A:A,Sheet2!(B+C3)) the '+'operator I'm used for concatenation purpose and not for addition AND =+Sheet2!("B" &C3)
but which is not working.