+ Reply to Thread
Results 1 to 6 of 6

Index formula won't work in French edition

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    66

    Index formula won't work in French edition

    I have a client who uses the French version of Excel and can't get the Index formula to work for him. Below is the formula I use in English and it works, he tries it in French and he gets a formula is wrong type of error. I strongly suspect the wording of being the culprit, but I'm not sure. Does anyone know how I need to change this formula to work in French?

    =INDEX('[HamburgContainer rate tender 2008(1).xls]Port of Savannah'!$D$4:$D$167,MATCH(1,('[HamburgSudContainer rate tender 2008(1).xls]Port of Savannah'!$A$4:$A$167=A4)*('[HamburgContainer rate tender 2008(1).xls]Port of Savannah'!$B$4:$B$167=B4),0))

    Thanks,

    Amy

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    In the formula replacing the commas with semi-commas should do the trick ( and maybe replace MATCH with EQUIV)
    This page can help : http://cherbe.free.fr/traduc_fonctions_xl97.html
    Last edited by arthurbr; 02-22-2008 at 10:39 AM.

  3. #3
    Registered User
    Join Date
    07-24-2007
    Posts
    66
    What is a semi-comma? I've never heard of that character, is it common in the French language?

    Thank you for helping me.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    it is a ; ( is that correct?)

    The formula should be
    Please Login or Register  to view this content.
    and maybe replace MATCH with EQUIV
    Last edited by arthurbr; 02-22-2008 at 10:42 AM.

  5. #5
    Registered User
    Join Date
    07-24-2007
    Posts
    66
    That's a semi-colon, but I finally figured out that's what you meant.

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    right ! did it help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1