Look Up Question Based Off Periodic Date

[MSC Bobs]

Hello everyone,

I have a problem I’ve not been able to solve and so I’m hoping someone here can assist.

What I’m trying to do is isolate records by month and then perform a VLOOKUP or a INDEX+MATCH, or some kind of look up, you get the idea.

I’ve got an inventory of widgets. I’m using a spreadsheet to maintain the records. The records are not updated daily. Rather, they are updated by hand (by me) and I only update the table when I use the widgets. I record how many widgets I use and the remaining count on hand. Widgets are not added daily, but are added in cases of 7 periodically. Because the table is not updated daily, I haven’t been able to figure out a way to use EOMONTH as a basis for my look up, if it’s even possible.

Once the month I select is isolated, I want to identify the MAX date, and also the MIN date and then base my look up off those values. This is where I’m stumped. I’m not married to using MAX and MIN, but that’s what I’ve tried.

I’d appreciate whatever help you are able to give. Thank you

 

[Nebu]

Hi:

I am not completely sure what you are looking for. However, I have construct some formulas as per my understanding.

Note: Both the formulas are array formulas execute it by pressing control+shift+enter keys.

Thanks

 

[MSC Bobs]

Thank you, I appreciate the quick response. You did what I was trying to do but I was unable to get it to work.