Look Up Values Between Dates

[mycon73]

Hi,

Conducting a financial reviews & seeking to modify this function to look up / index whole table instead of single column's but still give same type of results per column


'=LOOKUP(2,1/($D$23:$D$87>=C5)/($D$23:$D$87<=C6),F23:F87)

Will a VLookup work if can add between dates portion?

See example file

Thanks again for assistance

[mycon73]

Hi

Does anyone have a solution?

Cell D9

I modified to this but it's not working

=INDEX(D23:G39,MATCH(1,IF(E23:E39>=D5,IF(E23:E39<=D6,1)),0))

What's missing or needs to be modified?


Thanks

[mycon73]

Hi Group,

How to modify one of these or get solution to get desired results?

=LOOKUP(2,1/($D$23:$D$87>=C5)/($D$23:$D$87<=C6),F23:F87)

=INDEX(D23:G39,MATCH(1,IF(E23:E39>=D5,IF(E23:E39<=D6,1)),0))

Looking to simply worksheet because I have a relatively large or number of years to cover

Thanks

[Richard Buttrey]

...and what's the monthly balance when the table has several cells for the same date?

[mycon73]

Richard Buttrey

If there are duplicate dates, then 2 or more payments were made during same month

I suppose the higher balance should be captured along with full payments made during the month

Is this doable or make function a bit more complex?

[mycon73]

Hi Group

How to find value within table that between specific dates?

Date Due Monthly Balance Minimum Due Amount Paid


This works well if looking at date column & desired column but looking to minimize all the Name Manager inputs for 12 + worksheets


Thanks

[mycon73]

Hi Group

Still conducting financial reviews & seeking a way to either modify this function to look up / index whole table instead of single column's & get same types of results per column.


In my work file, I have multiple worksheets & the following function works well if name ranges or pointing to specific columns are defined.

=LOOKUP(2,1/($D$23:$D$87>=C5)/($D$23:$D$87<=C6),F23:F87)

Looking for ways to fast track the process or look up, vlookup, index the whole table instead.

In some of my tables, there may be multiple transactions within the same month. Not sure how to capture these - Primarily interested with Total Amount Paid per month


See example file

Thanks again for assistance

[Bo_Ry]

Please try at C12 drag to N12 and drag down

=SUMIFS(INDEX($E$26:$G$99,,ROWS(C$12:C12)),$D$26:$D$99,">="&C$8,$D$26:$D$99,"<="&C$9)

[mycon73]

Hi Bo_Ry

This works great!!

Awesome solution to (semi) complex scenario!!