Could you please show the expected result? I can't find two sheets with ZIP codes

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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