Excel Help 2 worksheet compare 2 sets of data give quantities associated

[mthauberger]

Hello I have the below spreadsheet where I have to enter the value in cell P38. The data is on a separate worksheet call ProcessScans. Basically I need to find the 510-0042-02 (Cell P35) part in Process Scans AND verify the Material Receiving (Cell O38) category also in ProcessScans then find out how many went through that station which will give the final number in cell P38 (blank below).

510-0042-02 (P35)
Material Receiving (O38) ?? (Result by grabbing 510-0042-02 AND Material Receiving from worksheet Processscans!)



So in summary I had 55 systems of part 510-0042-02 go through Material Receiving by grabbing all the information from ProcessScans which comes from our system? I tried index/match and VLOOKUP but all are giving me errors.

Thanks in advance for your help!