Populate a cell from data matched from 3 other worksheets

[DWAYNE64]

I was able to use the IF function to match all of the sells in each work sheet but have been unable to figure out how to pull the SYSTEM# from each MASTER into the inventory sheet matching the CCSD row D.

I was able to figure out how to add the IF function to the individual worksheets but I have no idea what function would pull the SYSTEM# from the matching MASTER worksheet.

I'm attaching working document I have so far I was able to use the count function to add up quantities and the conditional format to set up the formats.

Any ideas?