vlookup many - add row

[rowbro]

Hi guys.

I have a strange excel document that I need a bit of help with:

The first sheet has a user input for just one thing - a "Project Code". When this has been entered by the user, I want the sheet to auto display an "expenditure item" and "value", looked up from the second sheet in the document. This is easy enough using vlookup, BUT for each project there may be up to 16 expenditure items. The second part of this problem is that while there MAY be up to 16, most projects have about 4. So what I am trying to do is to display all of the expenditure items from the second sheet (per project) if they contain a value greater than 0, but in such a way that only the number of rows that are required for the number of expenditure items with values greater than zero are used up (i.e. I don't want a whole lot of blank cells/rows due to the POSSIBLE (but unlikely) 16 expenditure items).

Anyone got any bright ideas?

Many thanks

 

[Comfy]

With alittle VB you could:

Filter the data using the project code entered and Value > 0

You could then copy that info to sheet 1 as a picture.

 

[rowbro]

Thanks for the reply. Is that really the only/best way of achieving this? I was hoping that there would be some clever solution using arrays and VBA.

 

[Comfy]

Oh No. Definately not the only way, just a suggestion.

Array is possible but I would be of no help in that respect

 

[rowbro]

Are there no other ideas as to how I can achieve this? I am sure it cant be impossible!