I figured out a few things but still have been unable to get the Cell in the invoice to pull the matching system number after a match is found with the CCSD and what ever master sheet it was found on?

After messing around I noticed that I needed to have the array function on each cells function! {} and that to keep the numbers from changing on the search field I had to use the $A$1:$A$400 this little bit frustrated me after multiple attempts to write the function over.