Thread: Numeric in Text to convert back to the form of Numeric for VLookup Purposes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Numeric in Text to convert back to the form of Numeric for VLookup Purposes
Suppose your account no. is in A1, try this:

=vlookup(value(a1),<range,......

Hans

Reply With QuoteReply With Quote