In non-program language: If a specific string of two characters exists, then use the string starting at the third character and of length 3, else display "INVALID"
Here is the code that displays the correct output, but ONLY if the string "US" exists. When it does not it displays "#VALUE!"
=MID($K10,FIND("US",$K10)+3,3)
Please assists in adding the "IF" logic
Here is the code that displays the correct output, but ONLY if the string "US" exists. When it does not it displays "#VALUE!"
=MID($K10,FIND("US",$K10)+3,3)
Please assists in adding the "IF" logic