Retrieve cell value basis the inputs into a diff cell // sk.
 

Hi !!

If the cell A5 has the value E
and the call B5 has the value 5
The formula CONCATENATE(A5,B5) will give me the result as E5.
How can i automatically retrieve what is the value in the Cell E5 ?

rgds, sansk_23.

Retrieve cell value basis the inputs into a diff cell // sk.
 

Try this:

=INDIRECT(A5&B5)

--
Biff
Microsoft Excel MVP


"sansk_23" wrote in message
...
Hi !!

If the cell A5 has the value E
and the call B5 has the value 5
The formula CONCATENATE(A5,B5) will give me the result as E5.
How can i automatically retrieve what is the value in the Cell E5 ?

rgds, sansk_23.

Retrieve cell value basis the inputs into a diff cell // sk.
 

Just use INDIRECT, viz.:
=INDIRECT(A5&B5)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sansk_23" wrote:
Hi !!

If the cell A5 has the value E
and the call B5 has the value 5
The formula CONCATENATE(A5,B5) will give me the result as E5.
How can i automatically retrieve what is the value in the Cell E5 ?

rgds, sansk_23.

Retrieve cell value basis the inputs into a diff cell // sk.
 

Thx.
Further if i have the formula for :
North as - SUMIF($C$1:$Z$1,"N",$C$19:$AA$19)
South as - SUMIF($C$1:$Z$1,"S",$C$19:$AA$19)
West as - SUMIF($C$1:$Z$1,"W",$C$19:$AA$19)
East as - SUMIF($C$1:$Z$1,"E",$C$19:$AA$19)

and for the portion "$C$19:$AA$19" from the above formulas,
i want the row no "19" as an input from another cell , ssay A1.
If i change the value of the cell A1 to 20, then the above formulae should
turn to :
North as - SUMIF($C$1:$Z$1,"N",$C$20:$AA$20)

Pls advise.

rgds, sansk_23



"Max" wrote:

Just use INDIRECT, viz.:
=INDIRECT(A5&B5)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sansk_23" wrote:
Hi !!

If the cell A5 has the value E
and the call B5 has the value 5
The formula CONCATENATE(A5,B5) will give me the result as E5.
How can i automatically retrieve what is the value in the Cell E5 ?

rgds, sansk_23.

Retrieve cell value basis the inputs into a diff cell // sk.
 

You could apply INDIRECT like this:
=SUMIF($C$1:$Z$1,"N",indirect("C"&A1&":Z"&A1)
where A1 will house the row number, eg: 20

Note that your SUMIF ranges should be consistent
(cols C to Z)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sansk_23" wrote:
Thx.
Further if i have the formula for :
North as - SUMIF($C$1:$Z$1,"N",$C$19:$AA$19)
South as - SUMIF($C$1:$Z$1,"S",$C$19:$AA$19)
West as - SUMIF($C$1:$Z$1,"W",$C$19:$AA$19)
East as - SUMIF($C$1:$Z$1,"E",$C$19:$AA$19)

and for the portion "$C$19:$AA$19" from the above formulas,
i want the row no "19" as an input from another cell , ssay A1.
If i change the value of the cell A1 to 20, then the above formulae should
turn to :
North as - SUMIF($C$1:$Z$1,"N",$C$20:$AA$20)

Pls advise.

Retrieve cell value basis the inputs into a diff cell // sk.
 

The formula should read:
=SUMIF($C$1:$Z$1,"N",INDIRECT("C"&A1&":Z"&A1))

(missed out the rightmost closing parens)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---