Forum Discussion

TariqRaza's avatar
TariqRaza
Copper Contributor
Jun 20, 2019
Solved

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 ...
Excelex
  • SergeiBaklan's avatar
    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,"")
      )
   )
)

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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,"")
      )
   )
)

 

  • TariqRaza's avatar
    TariqRaza
    Copper Contributor
    Jun 20, 2019
    Wow, its working.....:) Appreciated bro...hats Off !!!!!

Resources