Trying to copy filtered cell

[Xitmould]

Hi all,

New member as I can usually find my way through any issue I come up with but I'm stumped on this one.
Im trying to create a formula where I can Match Column C to a Cell in another Sheet with a "less than & greater than" value in I & J + Matching X to add the value of Y to a selected field on the other Sheet.
If I can achieve this I can apply it per row to finish a project I'm working on.

Apologies if this is unclear, the goal is to have the furmula Match the data within a single rows C, I, J & X data to output the number on that rows Y value as the sheet has about 75000 rows to filter through.

Ideally I would input matching C, a number between I & J to have this output the value of Y beside cells to match the value of X.

Edit, I can get the sheet to indivdually highlight the calls I want to be able to copy into another Sheet. I just need to automate said process instead of filtering and manually entering said values.

Cheers,
Beau.