|
|
#1
08-01-2023, 02:39 PM
|
|||
|
|||
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
08-01-2023, 11:00 PM
|
|||
|
|||
You are missing commas after each of ISNUMBER(... part of your formula!
|
|
#3
08-05-2023, 01:36 AM
|
||||
|
||||
|
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
|
|
| 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 |
Windows 10 
Office 2021
Linear Mode
