Forum Discussion
Formula Help
I am new to excel but am trying to accomplish what I think is rather difficult. I have many thousand items in Column A which is standard content from a product. I have requested items in Column B tha...
=INDEX($A$1:$A$12,MATCH(1,N(ISNUMBER(SEARCH(LEFT(B1,SEARCH(" ",B1)-1),$A$1:$A$12)))*N(ISNUMBER(SEARCH(RIGHT(B1,LEN(B1)-SEARCH(" ",B1)),$A$1:$A$12))),0))
Maybe with this formula if you are looking for an approximate match of 2 words in switched order.
Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Unfortunately that did not work. Thank you anyways!
