Pull 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 less than 1.5 in the first column AND has a % greater than 5%. Would I do this with the IF function, and if so, how do I create multiple conditions that would create this list? I want the list to spit out the A, AAA, etc. if possible when the conditions are met.



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!

[TonyB51]

Hi,

I have created a lookup type sheet.

Your Data did not meet any of the criteria you specified.

I used your criteria, but amended some values.

Try it.

Cheers

Tony