Thread: [Solved] How can I avoid doubles?
View Single Post
 
Old 05-10-2012, 08:03 AM
s7y s7y is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: May 2012
Posts: 38
s7y is on a distinguished road
Default

hi there Peter, here you have the formula as I use it

=vlookupx(A13;ULD!$A:$D;2;0;COUNTIFS($A13:$BB13;A1 3);(J17:AY17;A13);(G26:U26;A13);(AE26:AP26;A13))
Reply With Quote