Need help with a formula to lookup and extract info from a mastersheet that is database

[maryren]

Hoping someone can advise on the best way to do this. I need to pull certain fields from a database (data entered by multiple users). Specifically, I'd like to have a user type in a date field to search (column B, but I also have 3 other date fields, I do not want to search those columns, only B) and list specific cells from each line that shows that date in column B. In this case, I have 11 line items with a 1/6/14 date, and need to show detail data for each of those line items.

I tried a pivot and used the tabular form to display information, but it is not pulling the date from the column. The can't do an index and match (or don't think I can) because the information in the database is not in an ascending order and could not get vlookup to work either. Any suggestions?

I've attached a sample worksheet.

[RobertMika]

A21: Down and accross,
COnfirm COntrol+shift+Enter
=IFERROR(INDEX($A$3:$I$11,SMALL(IF($A$3:$B$11=$B$16,ROW($A$3:$A$11)-ROW($A$3)+1),ROWS($A$3:A3)),MATCH(A$20,$A$2:$I$2,0)),"")

[MarvinP]

Hi maryren,

This looks like a normal Advanced Filter problem to me. Learn about Advanced Filters and see if they don't do what you want.

http://www.contextures.com/xladvfilter01.html

[AlKey]

Please attached file on sheet2

[AlKey]

Thanks for the feedback!