You can use vlookup function to finish it. Please refer to the details： https://www.excel-easy.com/examples/vlookup.html
Comments