I am trying to write a If statement but I do not know how to make it answer the way I want it to.
I have two worksheets.
Sheet1 is where the answer will be. Sheet2 is where I am getting my information.

Sheet2:
Column:
A-----------B
Show1 Sunday
Show2 Monday
Show3 Sunday
Show4 Monday
Show5 Friday
Show6 Tuesday

I want to say if col B = Monday then show what is next to the monday ie. Show2 and Show4. I want to be able to run this on more than one cell showing all results in seperate cells.

This is something I do not think can be done but I am wondering if maybe someone might have an idea.
Thank you