Use =indirect(b1&c1)
On 5/6/09, Yu <vincent2...@gmail.com> wrote:
>
>
> Hi dear all,
>
> For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> has. Now B1 has value"A", and C1 has value "1", I want D1 has the
> formula "=A1"
>
> It doesn't work when I type "=B1&C1" in D1... Can anyone gives
> some shine on it?
>
> I know how to do it in VBA..quite easy: range("D1").value =range
> (range("B1")&range("c1")).value. But i do not know how to do it on
> spreadsheet. Thanks
>
>
>
> A B C D
> --------------------------------------------------
>
> 10 A 1 =A1
>
> >
>
--
Sent from my mobile device
(¨`·.·´¨) Keep
`·.¸(¨`·.·´¨) Smiling !!
(¨`·.·´¨)¸.·´ Upendra Singh
`·.¸.·´9910227325
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
