index, lookup, nested ifs, which is best for...?
Posted by Aron Gahagan on December 17, 2001 12:26 AM
I have been working at this for hours and have gotten nowhere. I have Dates (mm/yy) in Column A, Prices in Column B. Then in Column D I start a table; Months D2:D13 (by number), Years E1:E11. (Except I have hundreds of rows in the real list.)
Now, I'd like to automatically enter the prices in B1:B10 to their correct cells in the table. I tried using CSEs, etc., like =if(month(A1:A10)=D2,if(year(A1:A10)=E1,B1:B10)) with the appropriate absolute addresses (I think). I planned to then copy this one formula down and across and...voila. I've tried everything else I can think of; Index(), Value(), everything...can somebody help?