Lookup Based On Criteria and Populate

• [INDENT=5][INDENT]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
  http://www.excelforum.com/exce…ria-and-populate.html</a>[/INDENT]

  
  

  
  [/INDENT]

  
  

Re: Lookup Based On Criteria and Populate

Hi,

I tried changing the parameters and the following is what happened:

1) Nothing changed in the data populated. It is the same data as per the attachment
2) No stock name is populated in cell B15 downwards.

For example, I entered more than $5.70 and less than $7.35 for last done and the following stock and the relevant data should have have populated:

[TABLE="width: 923"]

[tr]

[td]

Name

[/td]

[td]

Last Done

[/td]

[td]

Market Cap (M)

[/td]

[td]

PE

[/td]

[td]

Price/NAV

[/td]

[td]

High, 52 Wks

[/td]

[td]

Low, 52 Wks

[/td]

[td]

Revenue Growth

[/td]

[td]

Current Ratio

[/td]

[td]

Debt to Equity

[/td]

[td]

ROA

[/td]

[/tr]

[tr]

[td]

AMMB

[/td]

[td]

$ 5.76

[/td]

[td]

$ 17,361.71

[/td]

[TD="align: right"]12.886[/TD]
[TD="align: right"]1.633[/TD]

[td]

$ 7.05

[/td]

[td]

$ 5.30

[/td]

[TD="align: right"]10%[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]2%[/TD]

[/tr]

[tr]

[td]

CIMB

[/td]

[td]

$ 7.27

[/td]

[td]

$ 54,036.27

[/td]

[TD="align: right"]14.837[/TD]
[TD="align: right"]2.156[/TD]

[td]

$ 9.01

[/td]

[td]

$ 6.56

[/td]

[TD="align: right"]3%[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]1%[/TD]

[/tr]

[tr]

[td]

RHBCAP

[/td]

[td]

$ 7.31

[/td]

[td]

$ 16,022.91

[/td]

[TD="align: right"]11.076[/TD]
[TD="align: right"]1.435[/TD]

[td]

$ 10.40

[/td]

[td]

$ 6.53

[/td]

[TD="align: right"]6%[/TD]
[TD="align: right"]3.2[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]3%[/TD]

[/tr]

[/TABLE]

However, when I clicked on the macro button, nothing happened.

Re: Lookup Based On Criteria and Populate

bump.

Re: Lookup Based On Criteria and Populate

bump.