cell reference variable

P

PratishPatel

Hi
I need to use a value from cell as one of the variable in cell reference..

eg..

c1=108 ( The value in c1 ie 108 is the row no..)
So i want to use this row no as a variable to find values from different
coloum
For example : to get the value of E108 in to some cell... but instead of 108
i want to use it as a variable ....

So is their anyway to use something like E(c1)

Thanks
Pat
 
R

RagDyer

Try this;

=INDIRECT("E"&C1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi
I need to use a value from cell as one of the variable in cell reference..

eg..

c1=108 ( The value in c1 ie 108 is the row no..)
So i want to use this row no as a variable to find values from different
coloum
For example : to get the value of E108 in to some cell... but instead of 108
i want to use it as a variable ....

So is their anyway to use something like E(c1)

Thanks
Pat
 
G

Guest

hi
i am not sure how you are going to use it but you can do a
formula.
=("E" & C1)
for your example this would put E108 in the cell with the
formula.
 
P

PratishPatel

Thanks ...
Actually i have a huge access-list data...
So whenever i have to search for a perticular server's ip and password...i
have to use Edit->Find...which was not handy...

So instead i will use my list in different sheet...and on one of the blank
sheet i will create my own search ....
I am using =MATCH("*"&D3&"*",C34:C143,0) to get the row location of the
search string from D3...and on that result...i will use INDIRECT("e" & A3) to
fetch all the usefull records from that row ...
 
M

Myrna Larson

Use the INDEX function. Then

In A3, =MATCH("*"&D3&"*",C34:C143,0)

=INDEX(E:E,A3)
=INDEX(F:F,A3), etc.
 
Top