Thread: VLookup with Search for in String
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benjamin Benjamin is offline
external usenet poster
  
Posts: 102
Default VLookup with Search for in String
I need to look for this value within a cell

i.e.
A1XT-4-0713-01-00021-1.PDF

within Folder:Folder:Folder:Folder:FolderPath:A1XT-4-0713-01-00021-1.PDF
then return that row's third column's value.
Reply With QuoteReply With Quote