I have been using Vlookup to find a row of data with this code.
Formula:Please Login or Register to view this content.
A149 has the value of '13L - 40L'... up till now it hasnt mattered what was in the cell because the data i'm looking up had the same way of writing it. But now the data i'm looking up has changed how they reference it. Instead of '13L - 40L' its now '40L - 13L'. I thought of just changing all the references around to 13L - 40L but im looking for a formula that will look for both variables no matter what order they appear because I fear it may change again in the future and I dont have control of how the exported data comes to me. I'm assuming some sort of trim left or trim right might work but i'm not experienced with that.
attached is an exmple of what im doing and what i want to have as a result
Bookmarks