IF and VLOOKUP combined

Hi
This is my first time on this forum. I'm used to doing VLOOKUPs but not an IF as well.

In the attached file I want to put a formula in the red cells that says:
"Look in the Price List for the code in Col A - if the code has a Quan greater than 0 enter the detail in here. If the value is 0 hide the line."

I've done the VLOOKUP but need help with the rest of it. If anyone can help me that would be much appreciated.

Thanks

Try this:

=IF(VLOOKUP($A11,$A$3:$H$6,7,FALSE)=0,"",VLOOKUP($A11,$A$3:$H$6,8,FALSE))

That was great - it only brought through the detail on the items that had greater than 0. But it didn't hide the lines that had a 0 quantity.

Do I need to change the formula to put NIL in the lines that don't have a 0 and then find all the NIL ones and hide the lines? Or is there an easier way?

Try this in A10:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($G$3:$G$6)/($G$3:$G$6>0),ROWS($A$10:$A10))),"")

Copy down and cross.

Perfect!

Thanks!!!