We made the range longer and it worked
Claus: Try (The range is longer – it now goes to row 1000):
=IFERROR(IF(ISNUMBER(FIND(":",VLOOKUP(N2,'Avaya Data'!$B$1:$N$1000,3,0))),("00"&VLOOKUP(N2,'Avaya Data'!$B$1:$N$1000,3,0))*1,VLOOKUP(N2,'Avaya Data'!$B$1:$N$1000,3,0)),0)
Thanks Claus u da man. Case solved. Now if we could just find out who shot Biggie and Tupac :-/
|