Forum Discussion
Solved
XLOOKUP #VALUE! error
I am new to XLOOKUP. I am trying to lookup a value from spreadsheet A on spreadsheet B in order to find a value in a column associated with that value on Spreadsheet B. My current formula that is not...
bmaroni As a variant, using FILTER in stead of XLOOKUP
=FILTER(Domains!K:K,(Domains!A:A=E6)+(Domains!B:B=E6))
One more variant
=XLOOKUP( 1, (Domains!$A:$A=E6)*(Domains!$B:$B=E6), Domains!$K:$K, "nothing")- Thank you for your reply Sergei but for some reason this variant did not work for me.
