How can i have numbers from 2 columns match and return a third result?
So, this is how you can use index() with match() in column B to get the result from column E, it won't replace the contents of column A unless you do something with vba.