formula for finding value in a cell based on date

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I am trying to have my worksheet which, grabs a value out
of one cell and puts it in another cell based on the date.
If I can have the formula state.Example: If the Month and
day is, Then go to this row, If the Year is then go to
this column. Then it will find the answer and put it where
its suppose to be. If anyone can help me please e-mail me
at (e-mail address removed)
 
Hi Scott,
I did a similar macro in Excel4 macro language with index and match. (never
did update it)
Post a sample of how your data is laid out (or how you want it laid out) and
what cells or range you use.

If you are moving the data to another table, your looking at a VBA solution
not just worksheet formula.
 
Back
Top