Nested IFs Causing "Problem With Formula" Error

Fainit · #1 08-01-2023, 02:39 PM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround	MCamera	Excel	1	03-02-2022 07:52 PM
"Compile Error in Hidden Module" Problem	skeezix	Excel	1	01-03-2020 09:12 PM
Error opening file: "Found a problem with its contents"	PoppaDon	Word	5	05-03-2016 02:53 PM
How to use a "Save As" button without causing digital signatures to become "Invalid"?	jferg	Word VBA	0	02-16-2016 03:04 PM
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM