![]() |
|
#1
|
||||
|
||||
![]()
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
__________________
Using O365 v2503 - 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 |
|
![]() |
||||
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 |
![]() |
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 |