Announcement

Collapse
No announcement yet.

Formula error due to different languages (#N/A)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Formula error due to different languages (#N/A)



    Hello,

    I am running into a problem due to language settings.
    We have a sheet with various formulas using things like "=VLOOKUP($A5&TEXT($B5,"uu:mm"),source_data,E$1+3,FALSE)"

    The "uu:mm" is the standard dutch reference for what in english would be "hh:mm". I have Excel standard in English. So when I so anything in the sheet, the formula suddenly does not understand what uu:mm is, and generates #N/A
    If I manually change all the "uu:mm" to "hh:mm", the sheet works fine, but my collegues with Dutch excel get the error.

    Is there a workaround/bypass to allow me (with English excel) and my collegues (with Dutch excel) to work?

    thanks in advance

  • #2
    This maybe?

    =IFERROR(VLOOKUP($A5&TEXT($B5,"uu:mm"),source_data,E$1+3,FALSE),VLOOKUP($A5&TEXT($B5,"hh:mm"),source_data,E$1+3,FALSE))
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    Comment


    • #3
      Originally posted by AliGW View Post
      This maybe?

      =IFERROR(VLOOKUP($A5&TEXT($B5,"uu:mm"),source_data,E$1+3,FALSE),VLOOKUP($A5&TEXT($B5,"hh:mm"),source_data,E$1+3,FALSE))
      Hi Ali,... this works perfectly for me and my Dutch colleague.
      Thanks for the quick fix!

      cheers
      Alex

      Comment


      • #4


        Just a bit of lateral thinking!

        You’re welcome.
        Ali

        Enthusiastic self-taught user of MS Excel who's always learning!
        If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

        Comment

        Working...
        X