use 2 values on sheet 1 to search sheet 2 & return text on sheet 1

2-1 AD test.xlsm
Need to fill in sheet 1 col P (CODE#) and col Q (COST)
use sheet 1 col V value & col W value
to search sheet 2, and return text for sheet 1 col P
sheet 1 col V must match sheet 2 col E
sheet 1 col W value must be >= sheet 2 col F & <= col G.

I thought I could use 2 formulas
COST col Q =VLOOKUP(P2,'code list'!H:I,2,FALSE)

I know the VLOOKUP will give me col W (the price) but col V (the term)isn't unique on sheet 2
I think I've got multiple problems, and I think maybe I need to use MATCH for col V
I need the formula to return the 'CODE#' from sheet 2.
I've tried multiple variations with this:
=_______(AND(W2>=VLOOKUP(V2,'code list'!E:F,2,FALSE),W2<=VLOOKUP(V2,'code list'!E:G,3,FALSE)),_______)

how do i fix that, didn't mean to delete the post

sorry, I was just typing in any code (col P) to test the formula in col Q, forgot to delete it.

thank you,
index/match = much appreciated.
sitting here going through your formula, learned more from your formula than I did searching match/index on line for 4 hrs.
bye-bye vlookup, hello, index, match.
So, not only have you saved me many hrs, processing these sheets; I think you've given me a way to adjust other vlookup formulas I've been using on other sheets.

I'm going to start calling this site 'browes & learn'

thanks you