Compare data on 2 separate worksheets and pull a reference cell

I created a new column (N) on sheet INVOICE 0812. It checks if the values on column B and C exists on the other sheets (Master, Master 2 and Master 3)

See attached workbook.

This worked great!!!! it will help me tack down the numbers that are on each invoice!

Is it possible to do the same in reverse and have it pull the system number from each master list and auto fill it into the Invoice?

Or is that going to take a macro?

This fix has just taken about 2 days out of my life each month checking numbers!

Thanks so MUCH!

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.

I tried to solve your problem.

See attached workbook.