Formula is correct but the results don't show

[ConPellegrini]

I made a formula which consists of multiple IFERRORs with LOOKUPs and INDEX MATCHes. Basically, if th formula doesn't find the info, look it up on another workbook. The thing is... Inside the third (the last) IFERROR, the "value_if_error" part returns an information, if I press the F9 key on it. But, when I enter the formula, it returns nothing. The last IFERROR isn't even a IFERROR(...;""). I went through the whole formula, from inside out, using the F9 key and it is working just fine... I really don't know whats happening. Any ideas on what my be causing it and how to solve it?

Thanks in advance

 

[mole999]

can you post the formula, difficult to understand what you have without example

 

[ConPellegrini]

=IF($C10="";"";IFERROR(IFERROR(LOOKUP(2;1/(('S:\PCP-Gemot\Métricas\Semanal\[Master Gates.xlsm]Gates'!$B:$B)=VALUE($C10));'S:\PCP-Gemot\Métricas\Semanal\[Master Gates.xlsm]Gates'!$AE:$AE);INDEX('S:\PCP-Gemot\Production Plan\[Programação de Testes.xlsm]Prog. Testes - Celma & RIO'!$Q:$Q;MATCH($C10;'S:\PCP-Gemot\Production Plan\[Programação de Testes.xlsm]Prog. Testes - Celma & RIO'!$V:$V;0)));INDEX('S:\PCP-Gemot\Production Plan\[Programação de Testes.xlsm]Prog. Testes - Celma & RIO'!$B:$B;MATCH($C10;'S:\PCP-Gemot\Production Plan\[Programação de Testes.xlsm]Prog. Testes - Celma & RIO'!$G:$G;0))))

I don't know if you'll understand the formula because of the names of the workbooks... But it's just 2 nested IFERRORS that use Lookups and an INDEX MATCH

 

[ConPellegrini]

I found out what was happening... One of my lookups was returning empty string, so it was the result it was showing