I have a database which has a date, item code, and price. I need to look at the price for any single item during the past twelve months. There are many months in which the price is not changed, so I can't use a simple pair of sumproducts (or at least I haven't figured out how to do that). I'm grateful for any ideas! I have attached a sample.
Hi gren,
You can use the below formula:-
{=OFFSET($C$2,MAX(IF(($B$3:$B$12=$F3)*($A$3:$A$12<=E3),ROW($A$3:$A$12)-2,"")),0)}
attachment:- sampleTwoItemLookupWithDates.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks