how to find a character in a given range of cells in Excel

[kwfine]

Good evening all,

I am writing a simple program to find if there is a speicifc character in a given range of cells in Excel.
Here is an example:
From cells A1 to D10, there are 40 random characters, from A to Z.
Let say, if a character B is found, then it will return 2;
and it will return 3 if a character C is found, and so on.
If a character happens more than once, for example,
character B is found in cell A4 and cell D9, a number 2 will be returned instead of 4.

Here is what I can think of:
=IF(A1='B', 2, 0)
I don't know how to move on.

Could you help me out please?

Thanks in advance!
Kitty

[Carbon Dudeoxide]

VLOOKUP might work here.

Have a look at THIS thread.

[squall_01]

07 should allow you to do this, but I dont really recall unless your using an older version.