# Formula is correct but the results don't show

#### ConPellegrini

##### New Member
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?

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### mole999

##### Well-known Member
can you post the formula, difficult to understand what you have without example

#### ConPellegrini

##### New Member
=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

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

Replies
1
Views
435
Replies
0
Views
232
Replies
5
Views
157
Replies
2
Views
413
Replies
4
Views
522

1,196,006
Messages
6,012,823
Members
441,731
Latest member
jonceramic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back