Hi,

I have 100 entries of text which often differs by character or case. I am trying to somehow find the word in the text and use a formula somehow use a formula or macro, similar to a v lookup, which will return the corresponding number from a table. For example, as seen below, I would want to return pear from the text and then somehow return the number 3 from the table below it. I am unsure how to do this. Please help!

Text
AN APPLE
apple 24586
fdi banana
pear ghr
(a) pear

Fruit Number
Apple 1
Banana 2
Pear 3