Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect & addree combination
=INDIRECT("'" & A2 & "'!" & B2)
I taken this formula which is not working as in demo itself. Any body have the usage of like combinations of Indirect & address function in formulas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect & addree combination
Try the below formula in sheet1 cell C2...This will reference the sheet name
mentioned in cell A2 (in this case it is the sheet1 itself) and the cell mentioned in B2 (in this case it is A2)....So it will reference back to Sheet1 cell A2..Try changing the entries in A2 and B2 ColA ColB ColC Sheet1 A2 =INDIRECT("'" & A2 & "'!" & B2) If this post helps click Yes --------------- Jacob Skaria "Sekar" wrote: =INDIRECT("'" & A2 & "'!" & B2) I taken this formula which is not working as in demo itself. Any body have the usage of like combinations of Indirect & address function in formulas |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect & addree combination
Hi jacob Yes it is working , thanx for the same. Rgds Dharmasekar. "Jacob Skaria" wrote: Try the below formula in sheet1 cell C2...This will reference the sheet name mentioned in cell A2 (in this case it is the sheet1 itself) and the cell mentioned in B2 (in this case it is A2)....So it will reference back to Sheet1 cell A2..Try changing the entries in A2 and B2 ColA ColB ColC Sheet1 A2 =INDIRECT("'" & A2 & "'!" & B2) If this post helps click Yes --------------- Jacob Skaria "Sekar" wrote: =INDIRECT("'" & A2 & "'!" & B2) I taken this formula which is not working as in demo itself. Any body have the usage of like combinations of Indirect & address function in formulas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Combination Sum | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
combination | Excel Discussion (Misc queries) | |||
Indirect in combination with ROW | Excel Worksheet Functions |