Forum Discussion
Solved
Index/match formatting error?
Hi, I'm on Windows 10 and Office 365. I believe I'm making a formatting error when trying to continue a formula down a list. The current formula I'm using is " =INDEX(M5:O5,MATCH(A4,L5:L29...
Thanks. Try this formula in :
=INDEX($M$4:$O$2964,MATCH(A3,$L$4:$L$2964,0),MATCH(MAX(INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2694,0),)),INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2694,0),),0))
Fill down.
All names, addresses and figure are completely made up which is why I have no redacted any, thank you for the reply too
Thanks. Try this formula in :
=INDEX($M$4:$O$2964,MATCH(A3,$L$4:$L$2964,0),MATCH(MAX(INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2694,0),)),INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2694,0),),0))
Fill down.
- You're an absolute superstar thank you! It's worked perfectly except for the final 140 lines but I have no idea why
Sorry, that's due to a typo. It should be
=INDEX($M$4:$O$2964,MATCH(A3,$L$4:$L$2964,0),MATCH(MAX(INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2964,0),)),INDEX($R$4:$T$2964,MATCH(A3,$Q$4:$Q$2964,0),),0))