Hi elizo,

welcome to the forum.
Yes, you can use some lookup formula here... and would be better if you could upload a sample workbook along with your expected output. thanks.


Regards,
DILIPandey
<click on below * if this helps>