Funktionen MATCH

**Frederik123** · 04-06-2013, 04:22 AM

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å?

**Kevin UK** · 04-06-2013, 04:26 AM

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

=Match(1960;c6:c196;0)

**Frederik123** · 04-06-2013, 04:40 AM

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:-)

**Kevin UK** · 04-06-2013, 05:24 AM

Hi Frederik123

Without a sample file it is hard to say. Is the 1960 in column C a text value!
May be, try:

Formula:

Please Login or Register  to view this content.

**Frederik123** · 04-06-2013, 06:02 AM

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

**Kevin UK** · 04-06-2013, 06:06 AM

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.