Nested if functions issue

I am trying to use a nested IF vlookup function,

the formula checks whether the cell is less than 100, if it is then vlookup a workbook, if not then vlookup a different workbook, this works fine, however, i cannot seem to clear the #N/A from the empty cell

here is the formula :-

=IF(D393<100,VLOOKUP(D393,'M:\COMMUNAL\Rolling Stock\Fleet Planning\[Production Plan V4 DW.xlsm]Exam shedule'!$A$2:$E$152,4,FALSE),VLOOKUP(D393,'M:\COMMUNAL\Rolling Stock\Fleet Planning\[Production Plan V4 DW.xlsm]Exam shedule'!$A$2:$E$152,5,FALSE))

i have attempted to use ISNA, but because of the "D393<100 at the beginning of the formula it doesnt work

does anybody have any suggestions?

Try

=IFERROR(IF(D393<100,VLOOKUP(D393,'M:\COMMUNAL\Rolling Stock\Fleet Planning\[Production Plan V4 DW.xlsm]Exam shedule'!$A$2:$E$152,4,FALSE),VLOOKUP(D393,'M:\COMMUNAL\Rolling Stock\Fleet Planning\[Production Plan V4 DW.xlsm]Exam shedule'!$A$2:$E$152,5,FALSE)),"")

excellent, worked a treat, thank you.

i had previously tried IFERROR, but i had replaced the IF function with it

You're welcome.