Vlookup(s) problem

[Twinson]

I'm hoping someone can help me out.

I'm trying to automate the creation of a vendor report that lists al
vendor sales. Basically I need a formula that, based on a unique vendo
number, will:

- check colomn A for the vendor number match

- then check column B to see if there is a buyer number (which mean
that the item is sold)

- then dumps then 'nth' occurance of the value / text from the column
specify (8)

I'm currrently using the formula:

{=IF(Catalog!B2:B428
0,INDEX(VendorReportData,SMALL(IF(VendorReportData
=$N$13,ROW(Catalog!$A$2:$A$428)
ROW(Catalog!$A$2)+1,ROW(Catalog!$A$428)+1),2),2),0
)}

It's the =IF(Catalog!$B$2:$B$428>0) part of the formula that isn'
doing what I want. I want it to check to see that the value in column
based on the nth row is >0. At the moment it is returning the nth valu
in the list but not checking to see that the above condition is me
also.

She I be using the vlookup(s) formula for this