How to populate data by selecting codes.

how can I populate date by selecting codes like Ab Ac Ad AF, means when I select AB the automatically AB populates from 8:AM to 1:30 PM, same way AC populate 11:00 to 4: pm Time Slot 8:00 ...

Test.xlsx11 KB

Excelex

SergeiBaklan

Jun 20, 2019

TariqRaza

It's like

=IF(
   ($B6="AB")*(D$4>=TIME(8,0,0))*(D$4<=TIME(13,30,0)),
   $B6,
   IF(
      ($B6="AC")*(D$4>=TIME(11,0,0))*(D$4<=TIME(16,30,0)),
      $B6,
      IF(
         ($B6="AD")*(D$4>=TIME(11,0,0))*(D$4<=TIME(18,30,0)),
         $B6,
         IF(
            ($B6="AF")*(D$4>=TIME(8,30,0))*(D$4<=TIME(14,30,0)),
            $B6,"")
      )
   )
)

Test (14).xlsx12 KB

Forum Discussion

How to populate data by selecting codes.

Resources