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