+ Reply to Thread
Results 1 to 7 of 7

Funktionen MATCH

  1. #1
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Funktionen MATCH

    Hej, excel entusiaster :-)
    Jeg har indtastet følgende Formel Match("1960";c6:c196;0)
    Men istedet for 1960 skal der Stå en reference til en celle b6
    Men den virker ikke hvis jeg sætter reference ind?
    Hvad kan jeg gøre og er der andre måder at gøre det på?

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    Excel 2003,2007,2010,2013
    Posts
    1,914

    Re: Funktionen MATCH

    Sorry, but I do not understand Danish! But may be!

    =Match(1960;c6:c196;0)
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  3. #3
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Funktionen MATCH

    Hey, Kevin Uk :-)
    Here is my problem:
    The number "1960" works great but i wil had it to referer to the cell b6 where it also is :-)
    So i Will instead of write 1960 write That it shall referer to b6 :-)
    And when i referer it does not work:-)

  4. #4
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    Excel 2003,2007,2010,2013
    Posts
    1,914

    Re: Funktionen MATCH

    Hi Frederik123

    Without a sample file it is hard to say. Is the 1960 in column C a text value!
    May be, try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Kevin UK; 04-06-2013 at 05:56 AM. Reason: Changed the Comma to a Semicolon in the formula

  5. #5
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Funktionen MATCH

    Thanks :-)
    When i write b6&"" it works ;-)
    Can you explaine what it does when you say &""

  6. #6
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    Excel 2003,2007,2010,2013
    Posts
    1,914

    Re: Funktionen MATCH

    Hi Frederik123

    The lookup value that you were looking up was a text value (In column C:C). In D6 you had a number, so adding &"" converts that number to a text value.

  7. #7
    Registered User
    Join Date
    03-18-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Funktionen MATCH

    Hi Kevin
    Thanks for answer :-)
    Kind regards Frederik

+ 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