Thread: Lookup Based On Criteria and Populate

Hi,

I have a stock data in sheet 1 as follows:


Last Done
Market Cap (M)
PE
Price/NAV
High, 52 Wks
Low, 52 Wks
Revenue Growth
Current Ratio
Debt to Equity
ROA

In sheet 2, I have set a parameter table (cell c3 to c12) to enter a range of criteria. Based on these range of criteria entered in parameter table, I would like to populate all relevant stocks in cell b15 downwards and their respective data in cell b15 to l15 downwards in sheet 2 from sheet 1 that satisfies the criteria in the parameter table.

Is there a way to create a formula to achieve this?

Appreciate all help.

I have a cross post here:

http://www.mrexcel.com/forum/showthread.php?t=605515