In column A write this formula:
=IF(B3=$f$3, COUNTIF(B$3:B3, B3), "") drag this formula down.
In column G type formula:
=IF(ISERROR(VLOOKUP(row(1:1), $A$3:$C$100, 3, 0)), "", VLOOKUP(row(1:1),
$A$3:$C$100, 3, 0))
Hide column A.
Let us know if it works.

"Excel_Learner" wrote:

In column A write this formula:
=IF(B3=$f$3, COUNTIF(B$3:B3, B3), "") drag this formula down.
In column H make a list of 1, 2, 3, 4,............. and so on
In column G type formula:
=IF(ISERROR(VLOOKUP(H3, $A$3:$C$100, 3, 0)), "", VLOOKUP(H3, $A$3:$C$100, 3,
0))
Hide column A and Column H.
this trick can do your work.

"js" wrote:

Hi,
I have master list (B3:C8) and I'd like to display a list (G3:G4) based on
cell F3. How I could do that?
Thank you.

Column B Column C Column F Column G
Row 3 Fruit Apple Vegetable Cabbage
Row 4 Vegetable Cabbage Broccoli
Row 5 Fruit Grape Spinach
Row 6 Vegetable Broccoli
Row 7 Vegetable Spinach
Row 8 Fruit Orange