Thread: LOOKUP function help
View Single Post
  #4   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Perpmotion View Post
Thanks again. I know it was not a challenge for you, but it was driving me crazy! Have a good weekend.
Any time :)

The answer by the way for anyone interested was =VALUE(LEFT(CellRef,6))
Reply With QuoteReply With Quote