Thread: limit lookup search to left three places
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default limit lookup search to left three places
more info

--
Don Guillett
SalesAid Software

"roger" wrote in message
...
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