Compare data on 2 separate worksheets and pull a reference cell

This is a scaled down version of the inventory, my issue is being able to cut and past the formula from one month to the next and have each master update from the invoice and save the prior month data as it was updated. I plan to do this by just pasting the column as a value to keep the numbers.

My issue is linking the cells on each of the master documents to the invoice?

I can cut and past new formulas I just have know idea how to do the link?

The system numbers in orange need to make it to the inventory
The green on the master list will be the link from the inventory

I know its a mess!

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.