Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be Explode is the correct to do this!
I have 4 cell´s
1= colun 2 = line 3 = sheet 4 = result I dont know if is possible, but i fink tha is... I neet to do some thing like this in the cell results; (join the cell nº)=CONCATENATE(colun;line) (sheet name) =test Make like =CONCATENATE("'";sheetname;"'";"!";join) now i fink I have someting like this [ ='standard'!D28 ] Now, i need to make a formula off that, and only I can do is see the information on the cell Can some 1 Help me???? Thanks a lote!!!!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be Explode is the correct to do this!
Rui de Oliveira wrote:
I have 4 cell´s 1= colun 2 = line 3 = sheet 4 = result I dont know if is possible, but i fink tha is... I neet to do some thing like this in the cell results; (join the cell nº)=CONCATENATE(colun;line) (sheet name) =test Make like =CONCATENATE("'";sheetname;"'";"!";join) now i fink I have someting like this [ ='standard'!D28 ] Now, i need to make a formula off that, and only I can do is see the information on the cell Can some 1 Help me???? Thanks a lote!!!!!!!! You have to use the INDIRECT function also... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
May be Explode is the correct to do this!
Hi Franz,
Thanks for the information! I put the Indirect funtion, but i cant have a good result! But i loock better and i find the Adress function, so 1 put 1º the function Adress, and then the Indirect, and now is working good So, 1º I do the Concatenate =CONCATENATE("='Valores standard'!";R10) 2º The Adress =ADDRESS(1;4;R20;1;"Valores standard") 3º The Indirect =INDIRECT(R18) At this way is working good!!!! Thanks Franz!!! "Franz Verga" wrote: Rui de Oliveira wrote: I have 4 cell´s 1= colun 2 = line 3 = sheet 4 = result I dont know if is possible, but i fink tha is... I neet to do some thing like this in the cell results; (join the cell nº)=CONCATENATE(colun;line) (sheet name) =test Make like =CONCATENATE("'";sheetname;"'";"!";join) now i fink I have someting like this [ ='standard'!D28 ] Now, i need to make a formula off that, and only I can do is see the information on the cell Can some 1 Help me???? Thanks a lote!!!!!!!! You have to use the INDIRECT function also... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
World Cup tipping | Excel Worksheet Functions | |||
World Cup tipping | New Users to Excel | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
If correct, add 1 | Excel Worksheet Functions | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions |