Wow, that worked perfectly! Thank you so much!
Quote:
Originally Posted by Claus Busch
Hi again,
Am Fri, 26 Apr 2013 22:19:07 +0200 schrieb Claus Busch:
Then you can try in A4:
="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)&"."
you don't need the dot at the end.
Try:
="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|