Find row

[Mia]

Hi,

I´m trying to make a control of eralier cells, to find i same data.

I have tryed following, result, #saknas (in english missing????)

=LETARAD(O8;$O$2:O7;1;FALSKT)

And following, with the sam reslut.
=OM(LETARAD(O8;$O$2:O7;1;FALSKT)=O8;O8;"")

Do anyone know howe to solv this??

BR
Mia

 

[CurlyDave]

Hi,

I´m trying to make a control of eralier cells, to find i same data.

I have tryed following, result, #saknas (in english missing????)

=LETARAD(O8;$O$2:O7;1;FALSKT)

And following, with the sam reslut.
=OM(LETARAD(O8;$O$2:O7;1;FALSKT)=O8;O8;"")

Do anyone know howe to solv this??

BR
Mia

I am not sure what language this is, The formula looks like vlookup,
try this site
http://office.microsoft.com/sv-se/excel/HP052093351053.aspx