VLookup data in corresponding cells which contain formula and blank result

[EWolfe]

Hello,
Please see attached spreadsheet for reference.

The table (A1:P13) contains a schedule. In rows 2,5,8,11 there is a formula [=IF(ISBLANK(B18),"",B18)] in each cell that references the Rotation table (A16:BE21).
In rows 4,7,10,13 there is a formula [=IF(ISBLANK(B2),"",VLOOKUP(B2,$R$2:$T$5,3,FALSE))] in each cell that references the value in rows 2,5,8,11 and pulls a value from the Shift table (R1:T5).
In rows 3,6,9,12 there is a formula [=IF(N(B4),B4,0)] in each cell that pulls the value in the rows 4,7,10,13, those values are then summed in Column P.

Currently in rows 3,6,9,12 and 4,7,10,13 when the cells in 2,5,8,11 are 'blank' (formula only but blank result), I'm getting a result of #N/A, is there a way to have them return a blank result?

Thank you!

[AliGW]

You can use the IFNA error trap:

=IFNA(your_formula,"")

[EWolfe]

Hmm, that's not working I keep getting a "Problem with this formula" message.

In cell B4 I put:
=IFNA((=IF(ISBLANK(B18),"",B18)),"")
which is resulting in the problem with formula error.

[AliGW]

The extra equals sign is the problem! Try this:

=IFNA(IF(ISBLANK(B18),"",B18),"")

Or you can use this:

=IFERROR(IF(ISBLANK(B18),"",B18),"")

[EWolfe]

Beautiful! Thank you!

[AliGW]

No worries.