Repost with attachment
Hi all,
I’m using the index and match functions in the formula below to find a row that matches the value from cell PMP!$A3 in column PMPQueryAll!$C:$C and the value from cell PMP!B$1 in PMPQueryAll!$I:$I.
It then returns the values in that row from columns PMPQueryAll!$F:$F and PMPQueryAll!$H:$H.
This all works but is extremely slow. Can anyone help with a function or perhaps rearrange the formula to achieve the same result more simply?
=IFNA(INDEX(PMPQueryAll!$F:$F&" "&TEXT(PMPQueryAll!$H:$H,"dd/mm/yyy"),MATCH(1,INDEX((PMPQueryAll!$C:$C=PMP!$A3)*(PMPQueryAll!$I:$I=PMP!B$1),0),0)),"")
Thanks for taking a look at my problem 🙂
Bookmarks