0
At Book1 we have Sheet1, and Sheet2
At Sheet2 we have these values:
In Sheet1 in cell A1 we have this string: asc-7 ; in cell A2, we have the formula:
=CELL("address";INDEX(Sheet2!A2:D5;MATCH(Sheet1!A1;Sheet2!D2:D5;0);4;1)) and the value: '[Book1 (version 1).xlsb]Sheet2'!$D$1
How to show only: Sheet2'!$D$1 ?
1
You can manipulate this string with the following function in Excel in English, where A1 is the location of the formula =CÉL("endereço";ÍNDICE(Planilha2!A2:D5;CORRESP(Planilha1!A1;Planilha2!D2:D5;0);4;1)) and may be replaced by the formula:
=MUDAR(A1;1;PROCURAR("]";A1);"")
or in English Excel:
=REPLACE(A1;1;FIND("]";A1);"")
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Perfect! Which of the vectors returns the filename? We could use REPLACE in the constructor formula?
– texugo_indy
Yes, just replace A1 with the entire formula. I did it separately to simplify
– danieltakeshi