Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2005
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Closest match (Excel 2003)

    Dear All,

    I have a list of fund names and a list of file names (imported into Excel spreadsheet). Each fund name is associated with one file on the list. The problem is the fund name is not identical to the filename. Is there a supercharged lookup function that I can use to best match these two lists?

    Thank you in advance.
    Ridz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Closest match (Excel 2003)

    See <post:=551,730>post 551,730</post:> and the links provided by Steve (sdckapr) in his reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •