Forum Discussion
CatherineMadden
Mar 15, 2023Brass Contributor
Formula Help
Hello, I have tried all I know to do what I am trying, and it won't work. I could really use some help ASAP. I have a pivot table pulling off of the area in yellow and I am wanting to replace old...
HansVogelaar
Mar 15, 2023MVP
That would be
=IFERROR(INDEX(AH:AH,MATCH(1,(AF:AF=D2)*(AG:AG=H2),0)),"")
but it returns few non-blank results...
- CatherineMaddenMar 15, 2023Brass ContributorYeah it is still not working and I have tried all suggestions you all have givne me.