How to Return Text in XLOOKUP (replacing a IF and ISNA and VLOOKUP formula)

[yosarrin]

I have an existing VLOOKUP formula as follows: =IF(ISNA(VLOOKUP(@D:D;Logsheet!G:G;1;0));”not found”;”match”). I am trying to replace this with an XLOOKUP function. What the existing VLOOKUP and IF and ISNA combination does, is it checks if a particular unique number found in column D in the primary worksheet, exists in the G column of a separate worksheet titled Logsheet, if it does, it returns a “match” result, it it does not, it returns a “not found” result in excel 365. If someone could suggest a XLOOKUP equivalent formula I would appreciate it-I have tried a couple of what I thought were obvious formulas, but I end up getting a #SPILL! or #VALUE errors?

 

[Alex Blakenburg]

Since you are not returning the actual lookup value, you wouldn't normally use a lookup for it.
Also with your @D:D I am unclear of what you are actually looking up.

With the formula in row 2 I would be lookign more at something like this.

=IF(COUNTIFS(LogSheet!G:G,D2),"match","not found")

or

=IF(ISNUMBER(MATCH(D2,LogSheet!G:G,0)),"match","notfound")

The error position in XLOOKUP doesn't help you very much if you are not wanting to return the lookup value but only want to return "match"