#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
You are missing commas after each of ISNUMBER(... part of your formula!
|
#3
|
||||
|
||||
You also have the TRUE and FALSE answers after the third IF function, which actually stops everything.
Why use entire column references for the XLOOKUP? This " IF(EXACT(L4, "none"),IF(EXACT(N4, "none")," can be shortened to IF(AND(EXACT(L4, "none"),EXACT(N4, "none")),"NOT FOUND",... Please post a sample sheet with some data and some expected results Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
||||
|
||||
Did this solve your problem?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
formula help |
|
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 |