|
|
#3
07-27-2022, 03:24 PM
|
||||
|
||||
Thank you Arvi. The only time I used ISNA was in a code that was like IF(ISNA(VLOOKUP...) but then it simply became VLOOKUP.
I used the OR to find any number not equal to 1016, 1021 and 1022. Again, iyaman (this is how we say thank you). Edit: I added VALUE with the LEFT function to match with the number formatted criteria. =IF(ISNA(MATCH(VALUE(LEFT($B$4,4)),{1016,1021,1022 },0)),"B","A") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to skip repetitive lines to unique entries? | tbdesigns | Mail Merge | 1 | 07-05-2020 11:04 PM |
| Office 365 repetitive corruption? | markg2 | Office | 0 | 10-23-2019 04:18 AM |
| Creating a Report Template / User Form and/or Content Controls with repetitive data throughout | 53bigdog | Word VBA | 1 | 04-05-2016 04:00 PM |
| automating a repetitive process | vthomeschoolmom | Excel Programming | 1 | 02-28-2012 07:41 PM |
 repetitive work in word
|
vishalvijayan | Word | 1 | 03-31-2011 08:30 PM |
Windows 10 
Office 2019
Threaded Mode