View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default 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