Thread: Formula Dropping Leading Zeros
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tony h[_39_] tony h[_39_] is offline
external usenet poster
  
Posts: 1
Default Formula Dropping Leading Zeros

=LOOKUP(A7,{"0055622","0055625"},{"This worked 1","This worked 2"})


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505491

Reply With QuoteReply With Quote