How to check Status with a Vlookup

[Brazuca]

Hello,

I need help from you guys. I want to check the status from the ALL SHEET and if its active I will add the name to the route if is not then place "NEED DMR"

=IF(ISNA(VLOOKUP(E2,Driver,2,0)),Driver[@[Driver Name]],VLOOKUP(E2,Driver,2,0))

Driver = TABLE with all drivers

THANK YOU ALL

 

[Joe4]

Welcome to the Board!

Maybe try this:

=IFERROR(VLOOKUP(E2,Driver,2,0),"NEED DMR")