It is very sunny here in Cornwall today!

Now - I am puzzled. The Vlookup is as per your original formula in post#01

There are 2 things you can try next
1 Remove the 1 or 0 and the preceding comma (which sets the argument to default)
changing the formula to
...VLOOKUP(D9,Agency_Contract!C9:Y11,22)))

If that changes nothing then we must test the original Vlookup
2 Can you take one step back and verify the VLookup as a standalone function?
and confirm that it works

thanks