Hi everyone,
I ran into a pretty tricky situation here.
I use Index/Match function extensively to match up two spread sheets.
Our company has a coding system for materials to represent their different states.
For example, we have "ABC?", to show unsorted ABC. And we also have "ABC-", to...