Hey guys I don't know what is wrong with my formula... from everything I see it should work. I'm entering it with ctrl+shift+enter and other arrays are working.
I need to match both the date closest to or including a given date and match that to a customer's name.
Formula:
=INDEX('2020.07.30 Customer Balances'!O3302:O3316,MATCH(1,(("test")='2020.07.30 Customer Balances'!B3302:B3316)*(MAX(('2020.07.30 Customer Balances'!G3302:G3316<=R3302)*'2020.07.30 Customer Balances'!G3302:G3316)),0))
excelCapture.PNG
Bookmarks