Thread: limit lookup search to left three places
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger Roger is offline
external usenet poster
  
Posts: 226
Default limit lookup search to left three places
I need to do a look up based on the first three places in the reference cell

a1 is cda1428a I want the vlookup to return the data based on the cda only.

How do you do this?


Reply With QuoteReply With Quote