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))
=XLOOKUP(E6,IF(NOT(ISNA(XLOOKUP(E6,Domains!A:A,Domains!K:K))),Domains!A:A,Domains!B:B),Domains!K:K)
Maybe with this formula as shown in the attached file. It works in my spreadsheet with VLOOKUP as well.
Thank you for your reply Quadruple_Pawn your solution did work for me as well.