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. enter image description here