| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Function Help
Dear all, I have a sheet named "Nam" and I have another sheet in which cell A1="Nam" and in this sheet I have a formular to get value from cell C28 of sheet "Nam". For example ='Nam'!C28. My question is that Is there any function in Excel that I can get the value from C28 of sheet "Nam" by using sheet reference from cell A1, for ex. =A1 & cell reference. Thanks a lot! Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=381114 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Function Help
=INDIRECT(A1&"!C28") Manges -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=38111 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Function Help
Dear Mangesh, I tried but it didn't work. Thanks, Nam -- lehainam ------------------------------------------------------------------------ lehainam's Profile: http://www.excelforum.com/member.php...o&userid=18615 View this thread: http://www.excelforum.com/showthread...hreadid=381114 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Function Help
What did the formula return, did it return #Ref! error...? In cell A1, you should have Nam and not "Nam" Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=381114 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Function Help
Dear Mangesh, I think the formular should be =indirect(address(28,2,4,true,A1)) Regards, Na -- lehaina ----------------------------------------------------------------------- lehainam's Profile: http://www.excelforum.com/member.php...fo&userid=1861 View this thread: http://www.excelforum.com/showthread.php?threadid=38111 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Function Help
Both formulae work for me. Manges -- mangesh_yada ----------------------------------------------------------------------- mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047 View this thread: http://www.excelforum.com/showthread.php?threadid=38111 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming | |||
| Excel - saving result of a function without showing the function | Excel Programming | |||
![lehainam[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
