Microsoft Office Forums - View Single Post - [Solved] How can I avoid doubles?

Thread: [Solved] How can I avoid doubles?

View Single Post

Old

05-11-2012, 04:53 AM

Peter Wienand Peter Wienand is offline

Peter Wienand is offline

Peter Wienand uses Windows Vista

Windows Vista Peter Wienand uses Office 2003

Peter Wienand uses Office 2003

Office 2003

Novice

Join Date: May 2012

Posts: 15

Peter Wienand is on a distinguished road

Default

Try this

=vlookupx(A1,$A:$D,2,0,COUNTIFS($A13:$BB13,A13,J17 :AY17,A13,G26:U26,A13,AE26:AP26,A13))

Reply With Quote