Hi,

The data is random from a data base, in which I have to group together the fruit names. Therefore, for the example I am using Pear. This data that has been downloaded makes the data appear differently in each row. It differs by character and case. Ie (a) pear or PEAR.
I want to know if its there, but I also want to use some form of a formula like a v lookup which will return a corresponding value. Please see the table below as an example.
Thanks,

Fruit Number
Apple 1
Banana 2
Pear 3