I am using the following array formula to bring corresponding and most recent license status for list of vehicles:
=IFERROR(INDEX(VehicleList[Plate Status],MATCH(1,IF(VehicleList[Equip. '#]=A7,IF(VehicleList[Entry Date]=MAX(IF(VehicleList[Equip. '#]=A7,VehicleList[Entry Date])),1)),0)),"")
Cell A7 contains a vehicle ID number ([Equip.'#]), Vehicle List is a data source table. Some vehicle ID's have multiple entries on the list. The formula allows to pull the most recent entry for each vehicle.
What do I add to the formula to leave cell blank if the cell in the data source (Vehicle List) is blank? Thanks.
Bookmarks