Return a list ot items with a matching detail

[Wrathor]

I am trying to make a list of different items the all have a certain matching detail. The database is much too large for a pivot table.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
As an example; say you have a database that contains all the items you have. The database contains the Price, Number, Name, and Location of the items.<o></o>
<o></o>
I am trying created a list that will look up all the item's that have the same price. I want to be able to enter the price into a cell and have the list update automatically from that entry. I want the list to show items with matching price specific details (number, name, location).<o></o>
<o></o>
A breakdown of the list I tried but could not get to work; I can enter the price I’m looking for into cell C3, A3 does a countif to let me know how many items had that price shown in C3, starting in A5 and moving down to A29 I put in =IF($A$2>=1,1,"") and continued down until I got to =IF($A$2>=25,25,""), I'm trying to use A5:A29 as the Kth value, but cannot find a formula that will pull those into columns B C and D which should be number name and location from the database. <o></o>
<o></o>
Since my database contains ALL items with ALL the item details, I tried to look for a formula to would pull the Kth item for only the items with the same price.

 

[shg]

How about AutoFilter?

 

[Wrathor]

I'm not sure thats what I am looking for; unless I can make the filter reference the cell I enter the price into somehow.

 

[shg]

Then you could use Advanced Filter, and enter the criteria in the criteria range.

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

 

[T. Valko]

I am trying to make a list of different items the all have a certain matching detail. The database is much too large for a pivot table.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
As an example; say you have a database that contains all the items you have. The database contains the Price, Number, Name, and Location of the items.<o></o>
<o></o>
I am trying created a list that will look up all the item's that have the same price. I want to be able to enter the price into a cell and have the list update automatically from that entry. I want the list to show items with matching price specific details (number, name, location).<o></o>
<o></o>
A breakdown of the list I tried but could not get to work; I can enter the price I’m looking for into cell C3, A3 does a countif to let me know how many items had that price shown in C3, starting in A5 and moving down to A29 I put in =IF($A$2>=1,1,"") and continued down until I got to =IF($A$2>=25,25,""), I'm trying to use A5:A29 as the Kth value, but cannot find a formula that will pull those into columns B C and D which should be number name and location from the database. <o></o>
<o></o>
Since my database contains ALL items with ALL the item details, I tried to look for a formula to would pull the Kth item for only the items with the same price.

This sounds like what you're looking for but it's probably not too good if you have 1000's of rows of data unless you're using the file strictly as a database.

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[Wrathor]

Thanks Biff, That is exactly what I was looking for!

 

[T. Valko]

Thanks Biff, That is exactly what I was looking for!

Good deal. Thanks for the feedback!