danhendo888
Board Regular
 Joined
 Jul 15, 2019
 Messages
 129
 Office Version

 365
 Platform

 Windows
Book1  

A  B  L  
1  Vendor  Invoice  Reference  
2  1000010034  2216705  8190052331  
Burnard 
Cell Formulas  

Range  Formula  
L2  L2  =(INDEX(Sheet2!$L$3:$L$21835, SMALL(IF(FREQUENCY(IF(Sheet2!$K$3:$K$21835=$B2, Sheet2!$L$3:$L$21835), Sheet2!$L$3:$L$21835), ROW(Sheet2!$L$3:$L$21835)ROW(Sheet2!$L$3)+1), COLUMNS($L2:L2)))) 
Press CTRL+SHIFT+ENTER to enter array formulas. 
Above is what I am using currently.
Searching with one criteria; the invoice number.
Is it possible to search using two criteria? (invoice number + vendor number)
The tricky part is that there are duplicate values in column L for a given invoice.
If possible, it should look something like the below.
Book1  

I  K  L  M  
1  Vendor  Invoice  Reference  
2  1000010034  2216705  8190052331  
3  1000010034  2216705  8190052331  
4  1000010034  2216705  8190000001  
5  1000010034  2216705  8190000001  
6  
7  
8  Output:  
9  Vendor  Invoice  Reference  
10  1000010034  2216705  8190000001  8190052331  
Sheet2 
Last edited by a moderator: