FIRST POST! Wehoo!
Excuse my lack of excel knowledge...Im trying haha.
Thank you for taking the time to open this, and give it a read :biggrin:
Objective:
3 ways to demonstrate what I am trying to achieve.
Way #1 : D=(C1, B1:B), A1
Way #2: Search B1:B for absolute match in C1. Once match...