If <> Then pass , otherwise fail help needed

Hello,
Think is the very last question for my annoying document
In Column Q2 i want it to: Take the power from E2 , Find it in AL , and compare the ranges that are in AS/AT to the P2 result ... and if its within range then pass.. if not - fail

This is very similar to what i have done before, only cant figure out how to take the power then compare the ranges
Thx guys!

Try this in Q2:

=IF(AND(P2>=MIN(VLOOKUP(E2,AL:AT,8,0),VLOOKUP(E2,AL:AT,9,0)),P2<=MAX(VLOOKUP(E2,AL:AT,8,0),VLOOKUP(E2,AL:AT,9,0))),"Pass","Fail")

Then copy down.

Hope this helps.

Pete