Trying to copy filtered cell

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.

Hey thank you for any assistance you are able to provide, none of the data is sensitive as its all publicly available.
I can use conditional formatting to highlight exactly what I need, I just cant figure out the output part onto sheet1.

I have attached the file, with a lot of data deleted just so it isn't 30mb, but the fields on Sheet1 are whats required to filter the full document down to a single row.
Any help would be amazing.

I have the following that restores a "0" answer or false statement:

=IF(AND(E1=AADT_2012_2022!$A1,Sheet1!E2=AADT_2012_2022!$C1,Sheet1!E3>AADT_2012_2022!$I1,Sheet1!E3<AADT_2012_2022!$J1,Sheet1!C6=AADT_2012_2022!$X1),AADT_2012_2022!$Y1,)

What exactly does this mean?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	M	N
3	between I & J	CH

Sheet: Sheet1

OK - well, there don't appear to be any matching rows where 25 falls between the value in J and that in I, so please explain with a specific example what you mean by this.

One way:

=FILTER(Table1[AADT],(Table1[TRAFFIC_YEAR]=$O$1)*(Table1[ROAD_SECTION_ID]=$O$2)*(Table1[SEG_START_THROUGH_DISTANCE]<=$O$3)*(Table1[SEG_END_THROUGH_DISTANCE]>=$O$3)*(Table1[TRAVEL_DIRECTION]=$M6))

copied down. Or (all in one cell, no copy-paste)

=BYROW(M6:M8,LAMBDA(z,FILTER(Table1[AADT],(Table1[TRAFFIC_YEAR]=O1)*(Table1[ROAD_SECTION_ID]=O2)*(Table1[SEG_START_THROUGH_DISTANCE]<=O3)*(Table1[SEG_END_THROUGH_DISTANCE]>=O3)*(Table1[TRAVEL_DIRECTION]=z))))

Next time, please remember that a sample sheet is 10-20 rows, not 2000+++

Originally Posted by Xitmould

Attachment 851902

There is certainly values between this as I have them at the point where they are highlighted

That's column J alone, not the difference between I and J. No wonder I couldn't find anything!

This bit:

=FILTER(Table1[AADT],(Table1[TRAFFIC_YEAR]=$O$1)*(Table1[ROAD_SECTION_ID]=$O$2)*(Table1[SEG_START_THROUGH_DISTANCE]<=$O$3)*(Table1[SEG_END_THROUGH_DISTANCE]>=$O$3)*(Table1[TRAVEL_DIRECTION]=$M6))


You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.