Replacing cells that contain a particular value with a symbol

[flyngcoln]

Hi,
I'm trying to work out how to get a symbol to pop up in a cell when two other cells contain a certain value.

For example:

If A1 and B1 contain x and y combination, C1 has a rule attached that inserts a particular symbol or text (doesn't matter what) for that particular combination.

I'm trying to make an achievement matrix interactive by entering in achievement scores (in separate cells to the matrix) that I have already placed a rule on to categorise according to a pre set range. When the combination of these two data point are entered, I then want a symbol to pop up on the matrix to indicate where the two scores have put them.

I hope that makes sense

 

[flyngcoln]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Level[/TD]
[TD]1BB[/TD]
[TD]1B[/TD]
[TD]2BB[/TD]
[TD]2B[/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2AA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1AA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Score A[/TD]
[TD]1AA[/TD]
[/TR]
[TR]
[TD]Score B[/TD]
[TD]1BB[/TD]
[/TR]
</tbody>[/TABLE]

For example. The user has entered in their achievement scores in the table below the matrix. I have already placed a rule on the table to automatically convert the score to a level on the matrix. Now what I want to do is be able to automatically indicate where on the matrix this score correlates to. With a symbol, or text, or whatever - that bit doesn't matter so much, it could even be a #.
So for the sake of this example, you can see the indicator in the table with a
It may not even be possible.

 

[flyngcoln]

If someone could let me know if it's even possible, that would be great, thanks.

 

[JoeMo]

Maybe something like this in B2:

=IF(AND($B$8=$A2,$B$9=B$1),CHAR(8),"")

copied across and down to cover B2:E5. $B$8 is Score A and $B$9 is Score B. Format B2:E5 bold, red.