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?
--
en

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"envy" wrote in message
...
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?
--
en