Populate Text based on conditions

  • Thread starter Thread starter envy
  • Start date Start date
E

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?
 
Back
Top