 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008help please!
The problem is that I need some help in Excel. Let me explain: Here is an example: If we say that a cell like C5=7 and we need A7, then we could say that it's the same as A(C5). But Excel don't understand it.Why?Is there any other way to write it,to understand?? Thanks,I will wait for your response. =INDIRECT("A"&C5)  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > The problem is that I need some help in Excel. > Let me explain: [quoted text clipped - 4 lines] > way to write it,to understand?? > Thanks,I will wait for your response. Hi In addition to Sandy's method, if you want the value that is in cell A7 then you could also use the non-volatile =INDEX(A:A,C5) SignatureRegards Roger Govier > =INDIRECT("A"&C5) > [quoted text clipped - 6 lines] >> way to write it,to understand?? >> Thanks,I will wait for your response. try ="A"&C5 Greetings from New Zealand > The problem is that I need some help in Excel. > Let me explain: [quoted text clipped - 4 lines] > way to write it,to understand?? > Thanks,I will wait for your response. So you are saying that you want to read cell C5, and that cell has a value of 7. Then, you want to put an Ain front of the 7 and make some other cells value A7?? If that is what you want then you can use the CONCATENATE function. Type that into the help section and the explanantion should suffice > The problem is that I need some help in Excel. > Let me explain: [quoted text clipped - 4 lines] > way to write it,to understand?? > Thanks,I will wait for your response.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.