=MATCH not working as intended - what am I missing?

[vicber]

Hello guys,
I hope you can shed some light on this:

Looking for a Date in specific ranges
There are 4x the same date in two different lookup_area
2x in each area

I have a this formula, =MATCH(F61,B4:BK4) which returns the correct column number
Date in F61 is present in AR4 & AS4, it returns AR4 (44), which is what I want

In the same worksheet, I have this =MATCH(F61,BL4:DU4), which returns the same column number (44), even if the lookup_area is not the same
Date is also present in DB4 & DC4, I expected the formula to return 106 (column DB)

Why is the second formula not returning column 106 (DB), as it should? (or, I guess, it does what it should, but not what I expect)

Thanks in advance
Bernard

 

[vicber]

I found a way of having this working....should have put more thoughts before posting.
I'm now looking after the last instance of the date in the array, and will work from there instead of the MATCH

https://exceljet.net/formula/get-last-match

Bernard

 

[steve the fish]

Its returning 44 because DC4 is the 44th cell in the range BL4:DU4 where it finds the date in a presumably sorted list of dates.