Return the value that falls within multiple ranges

I'm assuming you're wanting a formula to go into cell F3 on Sheet1 (and copied down)? I know you're going to supply another sample file with expected results, but please make sure to explain those results. If I just look at your current data, I don't know what would go in the CODE column for row 3. Initially I would say Code: CPR2004, as the 50 fits within the range for CW, but the value for GA doesn't fit in the range, nor does the WD Value. I'm sure it will be made clear once you post again

Hello, I updated my original post, could you please take a look at it?

My results don't agree with your mocked up answers - I'm hoping it was a mistake on your end. Also, you don't say what to do if the values satisfy more than one Code. My answer shows all codes that match, extending additional codes to the cells to the right. Please try this in Cell G2 and copy down:

=TRANSPOSE(FILTER($K$2:$K$22,(A2=$L$2:$L$22)*(B2=$M$2:$M$22)*(C2=$N$2:$N$22)*(D2>=$O$2:$O$22)*(D2<=$P$2:$P$22)*(E2>=$Q$2:$Q$22)*(E2<=$R$2:$R$22)*(F2>=$S$2:$S$22)*(F2<=$T$2:$T$22),"N/A"))

Thank you so much! It works like a dream on my Excel file!!!
However, I'm trying to get the same results on Google Spreadsheets and it's giving me the error below, I looked this up and tried the formula below and is still giving me an error..
Could you please help me with this too?
"FILTER has mismatched range sizes. Expected row count: 21. column count: 1. Actual row count: 1, column count: 1."

> =IFERROR(TRANSPOSE(FILTER($K$2:$K$22,(A5=$L$2:$L$22)*(B5=$M$2:$M$22)*(C5=$N$2:$N$22)*(D5>=$O$2:$O$22)*(D5<=$P$2:$P$22)*(E5>=$Q$2:$Q$22)*(E5<=$R$2:$R$22)*(F5>=$S$2:$S$22)*(F5<=$T$2:$T$22))),"N/A")

Sorry, don't know Google Sheets well. Glad it worked in Excel though.

Originally Posted by Gregb11

Sorry, don't know Google Sheets well. Glad it worked in Excel though.

I figured out through the spreadsheet community, Thank you so much for your help!