Forum Discussion
Solved
Formula Index Match
https://1drv.ms/x/s!Agmju254hK9cgxTt7kQkOE1x2QGe Hi All, I am looking for a formula, was helping it could be an =iferror, index match... but I'm sure somebody may have a better one that would...
What happens if you confirm the formula by pressing Ctrl+Shift+Enter ?
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)),"")
=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)),"")
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