I have reuploaded sample workbook with labels. The original workbook has 50,000+ rows in facility name worksheet (WS2) and about 100 operations codes (WS3). The sample does not yield any matches below.

Here are the desired functions I want to perform:

On WS1 take data in B4
Look up match in W2 Col A
Take data in Cols B & C & import to WS1 G4 & H4

Take WS1 C4
Look up match in Col A
Take data in Cols B & C & import to WS1 I4 & J4

Thanks,

Keith