Nested IFs Causing "Problem With Formula" Error
Excel is not recognizing my formula and says "there's a problem". I'm sure it's something simple and I have become blind to it. I need a second set of eyes.
=IF(EXACT(L4, "none"),
IF(EXACT(N4, "none"),
"NOT FOUND",
IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!N4, Transmitters!A:A, Transmitters!H:H)))
"No",
"Yes")),
IF(ISNUMBER(SEARCH("none", XLOOKUP('IB List - by Part#'!L4, 'II-Kits'!A:A, 'II-Kits'!I:I)))
"No",
"Yes"))
Sorry, the code block is not working in my browser.... I guess?
|