Conditional Arbitrary lookups

[Twinson]

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

- check column B to see if there is a buyer number (which means tha
the item is sold)

- checks colomn A for the vendor number match

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

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)}

but changing the nth value isn't working correctl

 

[Twinson]

Small addendum:

It's the =IF(Catalog!$B$2:$B$428>0 part of the formula that isn't doin
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 nt
value in the list but not checking to see that the above condition i
met also.



{=IF(Catalog!$B$2:$B$428>0,INDEX(VendorReportData,SMALL(IF(VendorReportData=$N$13,ROW(Catalog!$A$2:$A$428)-ROW(Catalog!$A$2)+1,ROW(Catalog!$A$428)+1),1),5),0)