Need help with inputbox function

Hi, so my data has kids who are being billed "Weekly", "Monthly", and "Bi-monthly". It is dynamic data keeps on changing.

The problem is that On alternate weeks the data that needs to be pulled keeps on changing accordingly to their billing status.
If I put "Y" in the inputbox it takes a yes for the second string as well i.e it pulls the monthly kids as well.

here is the code so far: -

Please Login or Register  to view this content.

Change answer to answer2

Please Login or Register  to view this content.