Excel to lookup and return data on worksheet

[cinox]

Hi,

I`ve made a worksheet with an overview of my sheeps at the farm:

Sheep nr: 1111 Lamb nr: 9999

And i`ve made a new worksheet within a tab on my existing worksheet for the lambs.

And i have like:

Lamb nr: 9999 and i have Mother of lamb: <- and here i want word to automatic look up the first worksheet and return with sheep nr that matches lamb nr: 9999.

Someone know what function i can use and how i can do it?

Thanks

 

[cinox]

"=INDEX(Oversikt!A16:A21;MATCH("*"&A5&"*";Oversikt!I16:I21;0))"

i trye to use this formular to link to another worksheet in my excel.
but i get N/A!
do you see anything wrong in this formular?

thank you

 

[cinox]

i trye to use this formular to link to another worksheet in my excel.
but i get N/A!
do you see anything wrong in this formular?

"=INDEX(Oversikt!A16:A21;MATCH("*"&A5&"*";Oversikt!I16:I21;0))"

thank you for the support

 

[VoG]

That formula looks OK to me.

 

[cinox]

i only get N/A.

When i use Index and Match in same sheet it works, but when im trying to use Index and Match from other sheet tab it returns N/A