Forum Discussion
XLOOKUP multiple lookup values and return checkbox if all return values <> a specified value!
I have to be overthinking this, but I can't keep "spinning my wheels" - Any advice would be very much appreciated! I have two worksheets. I have attached an example with parts of the worksheets in t...
Hi ShainaDay88
Assuming the workbook you shared reflects reality your challenge started with Trades stored as Numbers in columns G-L, stored as Text in column Q. Matching Numbers in Text doesn't work with lookup functions. Converted Trades in Q as Numbers in attached file
One way, in N3:
=LET(
trades, COUNT(G3:L3),
lookvalue, FILTER(G3:L3, ISNUMBER(G3:L3)),
aresold, XLOOKUP(lookvalue, TRADES[TRADE SERIAL NO.], TRADES[TRADE STATUS], "") = "sold",
IFS(trades = 0,"", SUM(--aresold) = trades,"þ", TRUE,"")
)