View Single Post
 
Old 08-01-2023, 02:39 PM
Fainit Fainit is offline Windows 10 Office 2021
Novice
 
Join Date: Aug 2023
Posts: 2
Fainit is on a distinguished road
Question 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?
Reply With Quote