I have two problems,

First I need to compare a month in a column with a date in a row.

For example: column b has dates like this 7/06, 8/06, etc.

In another sheet, i have the months across the top like January,
February. (these are in different columns).

I need to compare column b month with the month in the other sheet. If
it is true, then I need to take a value from column k (on the same
sheet as column b) and put it in that corresponding column. Like the
column for july would have an amount in it.

Second, I have column c that has number of months.

What I basically need is an if statement and lookup that will look at a
column with dates and put an amount from column k in the corresponding
column in another worksheet. At that point, it will look at the number
of months column and insert the amount in however many columns it says.


For example: column b, is 7/06. Column J (another sheet) is July, and
column k is 87,500 and column c is 6. It will look something like this:

January, February, March, April, May, June, July, Aug, Sept,
Oct, Nov, Dec
87500
87500 87500, 87500, 87500,87500


My lookup is like this:


=VLOOKUP(Sheet2!D4,startdate,1,FALSE)

but this gives me '38904'.

any help would be appreciated.