View Single Post
  #2   Report Post  
dlireland dlireland is offline
Junior Member
 
Posts: 2
Default

Wow, that worked perfectly! Thank you so much!

Quote:
Originally Posted by Claus Busch View Post
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