Excel 2007 : sorting data if conditions are met..

[bjh3a]

Ok, thanks again for the help on the last post. This question sort of feeds of what I asked previously, so let me explain the situation:

I got the VLOOKUP to finally work, and sort the data I wanted. Now, of of the list I populated, I'm trying to pull out certain things IF two certain conditions are met, example:

A..............1..............1%
AA ............2 ............6%
AAA..........2.3............3%
B..............1...............5%
BB............3 ..............7%
BBB...........2..............2%

Now, what I'm trying to do is create a function that will pull data that has a number greater than 1.5 in the first column AND has a % less than 5%. Would I do this with the IF function, and if so, how do I create multiple conditions that would create this list?



Then, another question, to save time... I want to find the median of the second column, if and only if the values are GREATER than 1. So, question is.. how do I create the function to where it searches through the first column to look through the second column for that specific condition, then computes the median of that selected data?

I appreciate everything guys, you've been so much help!