View Single Post
 
Old 07-27-2022, 03:24 PM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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")
Reply With Quote