Populate Text based on conditions

[envy]

Hi -
I am trying to determine a way to populate text based on input conditions.
My example is with moon phases. I have all the moon phases based on date as
follows in one sheet:
A B
Date Moon Phase
9/2 1st
9/3 1st
9/4 Full
etc..

In another I have a table where the user inputs the date she worked and I
want it to automatically fill in the second column with the Moon phase
A B
9/4 NEED FORMULA
9/6 .....

I am so lost. Anyone know how to work this?

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html