I want to allow a user to enter a data value in a cell, then create a row
listing based on looking up the user entered value in a table array.

I have the following sample data listed on the "Data" tab of a workbook.

ASR TABLE
AcctSecRefKey.....AcctKey..........SecIDKey.....Re g.....Loc.....SecID.....SecIDType
ASR1..........AK1..........SID2..........REG1..... BBH.....ID2.....ISIN
ASR2..........AK2..........SID2..........REG1..... SSB.....ID2.....ISIN
ASR3..........AK3..........SID2..........REG1..... DB.....ID2.....ISIN

The user wants to create a list of AcctSecRefKeys WHERE the SecIDKey = SID2.

Thus, on a second tab, named "User Entry", the user will enter a SecIDKey
value in a cell (A1), and then I want the formula to create a row listing of
the corresponding AcctSecRefKeys (i.e., ASR1, ASR2, ASR3 in cells A2:A4).

I've seen several posts that hint at how to do this, but haven't found one
yet that explicitly defines how to accomplish this.

Thanks in advance for assistance.

--
Thanks,
Jen