Vlookup Issues

Just use XL's filter

Thanks for your responses.
Judgeh59, Im looking for something that automatically updates when values are changed (Im not too great at excel, and to me something with a Sub means a macro that needs to be run).
Arthurbr, I cant just use the filters because I need the positioning to stay the same. My ultimate purpose is for the user to go down a list of 9000 items, select which ones they want by entering a price, and have a full list at the very bottom of just the products they added a price to.

Here is what is currently on my mind, and im sure im making this more complicated than it needs to be. Im thinking about adding a number scheme to a random cell in a row, and if the price is greater than 0 in that row, the number scheme will increase, and I will then do a vlookup on that number scheme. However, I get the feeling this will involve many very annoying IF statements.

Example File.xlsxHello Brilliant minds! I am new to this forum but very excited to be here.

I am not sure how to start a new Forum/Question so I thought I would pose my question here.

I am trying to use Sum a VLOOKUP where Table has multiple values that = the ONE lOOKUPVALUE.

This is a very complex spreadsheet but I simplified the results in an easy to ready simple spreadsheet.

Please see attached document.

Any help is greatly appreciated!

Have a wonderful day.

Zsalem,

I'd be happy to attempt to help while im in the excel thinking mood; to post your own thread, you go into a forum (such as the VBA), then click the big "Start new Thread" button at the top left; one of the forum rules is to start your own thread, so one of the main members of the forum will probably come in, delete your question and tell you to go to your own. Until then, can you try to explain your sheet a bit more clearly?

I can see that working. Ill prepare a quick test-file to show exactly what im looking at, and ill post it momentarily. Zsalem, see attached file (this is what I was understanding from what I read).

So, to explain this attachment, In column C I have all of my products, and in column E I have prices entered by the user, and for products they aren't pricing, they leave it alone. At the bottom, I want a straight list of the products that have prices.

judgeh59, your example does exactly what im looking for, though im hoping for something that is updated automatically (and im personally not aware of a way to do that with vba code without slowing the sheet down significantly)

I managed to solve my issue by using the MAX function. My final function is: =IF(H7="",$A$3,IF(H7=H3,MAX($A$1:A4),MAX($A$1:A4)+1)); to spell it out, if the price = 0, return a preset value of 0, if the price isn't 0, run an if function that says "if the price is the same as the previous price, use the max function to return the highest number in the column (which would be returned by the previous price, thus having them be the same number), and if the price isnt the same as the previous price, use the max function to find the highest number in the column before the cell, and add 1. Then I just used vlookup at the bottom of the page to look for the numbers 1-50.

The only issue I still have is the vlookup wont work if there are multiple items with the same price (which isn't a crazy huge issue for me personally).