Lookup value position in a list

[Broobi]

Hi All

Please could someone help me out?

Is there a formula that will return the number location of a value in a list?

So, If my list was, for example, (from A1 to A6) Eggs, Fruit, Milk, Apples, Pears, and Lettuce... Milk is the 3rd item in the list. So is there a formula that can look in the list for 'Milk', then return the number 3 (for 3rd item)

Hope I'm making sense?

I tried using, LOOKUP, but that just returns the word, not its number in the list

Many thanks in advance for your help

[ChemistB]

You want MATCH
=MATCH("milk", $A$1:$A$6,0)

[Broobi]

Perfect! Thank you ! :D