Hey All:
Hope everyone is keeping safe. Need some assistance with the attached sample file. I'm trying to match values in two columns to return the value in a third column. I've used something like this many times:
=INDEX($D2:$D8,MATCH(@$A2:$A8,$F2:$F8,0),1),INDEX(D2:D8,MATCH(@B2:B8,G2:G8,0),1)
But it doesn't seem to be working any longer. Probably since we moved to O365. I've tried it as an array, too. Basically, trying to say if A:A and F:F match AND B:B and G:G match then return the value in the D:D.
I've put some notes in the sample file and would greatly appreciate any guidance. I'm sure it's something obvious, but racking my brain at the point.
Thanks
WHH3
Bookmarks