View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claud Balls Claud Balls is offline
external usenet poster
 
Posts: 72
Default Automating conform of cell contents so they MATCH

In your VLOOKUP formula, leave the zero out. For a description why
search Excel help for VLOOKUP and check out the range_lookup value.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!