Hi Yu,
Please use
=INDIRECT(B1&C1)
Please let me know if it helps.
Regards,
Andy
On Wed, May 6, 2009 at 9:34 PM, 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
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
