Help with a formula which will provide a value after two text cells are selected

Hi, I'm looking for a formula, hopefully someone will help.
Basically I want to be able to select from two drop down lists a word, then once both of these words are selected, it provides me with a number.

So for example,

One drop down list will be country - So I would select UK, then on the second drop down list will be a type of fruit - so strawberries and then in the next cell it will generate a number and be 5.
I would like this to change dependent on the country and fruit. So if I still selected UK, but chose raspberries, it will say 10.

Could anyone help me with this?

Thanks

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?).

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

So there must be a reference table that lists countries and fruits.
Attach a sample file to show your layout.
Formula will depend on how it's setup.

Formula:

Please Login or Register  to view this content.

-

IndexMatch2.jpg

Woops, post has been edited.