How To Randomly Select Cells Based On Criteria In Excel?

I am looking for a help with a formula in excel. I have two tabs in my excel First tab - Updates

Second tab - One

When the input is 1, it should check if ID 1 is available in updates sheet and return a random "Code" column from "updates Sheet" which has ID 1. IF ID 1 is not available in Updates sheet, it should check in sheet "one" and return a random code from there which contains ID 1. When Input is ID 3, it should check in sheet 'updates', ID 3 is not available in updates sheet, so it should go to sheet 'one' and return a random code which has ID 3. My data here is dynamic,for example ID 1 values will keep increasing every month, so when a match is found it should return value. Please help on this.