Forum Discussion
Solved
xlookup formula
Hi, i have two sheets and i try to search multiple criteria using xlookup formula, it works for the first cell but when i drag down to copy the formula it shows the #VALUE! error (column R)
That could be
=XLOOKUP(L3&"="&$R$2,$A$2:$A$3641&"="&$D$2:$D$3641,$F$2:$F$3641,"")if you have XLOOKUP, otherwise INDEX/MATCH
=IFNA(INDEX($F$2:$F$3641,MATCH(L11&"="&$R$2,$A$2:$A$3641&"="&$D$2:$D$3641,0)),"")Both are in the file.
Riny_van_Eekelen unfortunately my excel does not support the filter function.
That could be
=XLOOKUP(L3&"="&$R$2,$A$2:$A$3641&"="&$D$2:$D$3641,$F$2:$F$3641,"")if you have XLOOKUP, otherwise INDEX/MATCH
=IFNA(INDEX($F$2:$F$3641,MATCH(L11&"="&$R$2,$A$2:$A$3641&"="&$D$2:$D$3641,0)),"")Both are in the file.