Forum Discussion

Copper Contributor

May 23, 2023

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...

excel

Formulas and Functions

office 365

HansVogelaar
May 24, 2023
Excelnoob02

What happens if you confirm the formula by pressing Ctrl+Shift+Enter ?

HansVogelaar

MVP

May 23, 2023

Excelnoob02

In B20:

=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)),"")

Format as a percentage. If Excel doesn't fill the entire table column automatically, do so yourself.

Excelnoob02
Copper Contributor
May 23, 2023
HansVogelaar

Thanks Hans, but not quite sure what I'm missing. Think you could narrow down my mistake?https://1drv.ms/x/s!Agmju254hK9cgxZgxzwATrV5CYqU
- HansVogelaar
  MVP
  May 24, 2023
  Excelnoob02
  
  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)),"")
  - Excelnoob02
    Copper Contributor
    May 24, 2023
    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)),"")