PDA

View Full Version : Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN



BENSON
10-11-2007, 08:09 AM
I have a spread sheet with 12 columns starting at column C representing the 12 months of the year(JAN -DEC) In column "A" a user enters a date and in column "B " a unit amount.I would like the unit amount to be refelected in the appropriate column ie: if the date is 3rd March the amount would show in column E

THANKS

p45cal
10-11-2007, 08:25 AM
if C2 is the top left cell of the data part of your data then paste this formula there:
=IF(AND(MONTH($A2)=COLUMN()-2,$B2<>""),$B2,"")
copy across the 12 months horizontally, then down as far as you need.
This only checks the month, not the year.

p45cal

ps if the top left cell is say, C6, then the starting formula would be:
=IF(AND(MONTH($A6)=COLUMN()-2,$B6<>""),$B6,"")