Multiple additional queries through IFS and regexmatch
If any H. E. Operator or Heavy Driver has a Valid or Expiring Soon Aramco License (Column F), Column H should display the value of Column F, otherwise display the value of G or E respectively.
If any H. E. Operator or Heavy Driver has a Valid or Expiring Soon Aramco License (Column F), Column H should display the value of Column F, otherwise display the value of G or E respectively.