Vlookup - 3rd post, help please!

[Twinson]

Basically I'm after a formula that can check two conditions befor
returning the value of the nth occurance I specify.

Specifically, I'm trying to automate the creation of a vendor repor
that lists all vendor sales. I need a formula that, based on a uniqu
vendor number, will:

- check colomn A for the vendor number match

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

If these conditions are met I need it to dump the value that appears i
column 8 of the 'nth' occurance I specify

I've used vlookups to great effect before in a similar report, onl
this time I need to check two conditions prior to returning the value.
The formula I've used in the other report is:

=INDEX(VLookups($N$13,ArtworkData,4),1,0)

In the vendor report, I'm currently using the following formula excep
that I can't work out how to get it to check the extra condition:

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

Thanks in advance :-

 

[Frank Kabel]

Hi
not tested but try

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

 

[Twinson]

Hi Frank, your formula worked an absolute treat! Thanks very much fo
pointing me in the right direction :-