Forum Discussion
Formula Index Match
What happens if you confirm the formula by pressing Ctrl+Shift+Enter ?
Thanks Hans, but not quite sure what I'm missing. Think you could narrow down my mistake?https://1drv.ms/x/s!Agmju254hK9cgxZgxzwATrV5CYqU
You have superfluous @ characters in the formula:
=IFERROR(INDEX('Pull YTD From'!$C$2:$C$244,MATCH(1, (@'Pull YTD From'!$A$2:$A$244=[@Employee])*(@'Pull YTD From'!$B$2:$B$244=[@[Outbound Task]]),0)),"")
should be
=IFERROR(INDEX('Pull YTD From'!$C$2:$C$244,MATCH(1, ('Pull YTD From'!$A$2:$A$244=[@Employee])*('Pull YTD From'!$B$2:$B$244=[@[Outbound Task]]),0)),"")
- For the life of me, I still cannot get it to work. I believe I tagged office 365, but it's professional plus 2016 if that makes a difference. Here is my formula
=IFERROR(INDEX('Pull YTD From'!$C$2:$C$244,MATCH(1, ('Pull YTD From'!$A$2:$A$244=[@Employee])*('Pull YTD From'!$B$2:$B$244=[@[Outbound Task]]),0)),"")Yes, on 2016
=IFERROR(INDEX('Pull YTD From'!$C$2:$C$244,MATCH(1, ('Pull YTD From'!$A$2:$A$244=[@Employee])*('Pull YTD From'!$B$2:$B$244=[@[Outbound task]]),0)),"")shall be entered as array formula with Ctrl+Shift+Enter.
If slightly modify and use INDEX for the second parameter of MATCH
=IFERROR( INDEX( 'Pull YTD From'!$C$2:$C$244, MATCH( 1, INDEX( ('Pull YTD From'!$A$2:$A$244 = [@Employee]) * ('Pull YTD From'!$B$2:$B$244 = [@[Outbound task]]), 0 ), 0 ) ), "" )it could be used as regular formula.
- Awesome! Thank you for the assistance
What happens if you confirm the formula by pressing Ctrl+Shift+Enter ?
- That worked great. Was able to get it working. Thank you for your time and help
