I have some Shape Data rows setup on shape 1. One of those rows is Prop.Letter and it contains a fixed list of A;B;C;D. If I set Scratch.A1 to be =Prop.Letter, then Scratch.A1 shows the selected value (A, B, C, or D) as it should. If I put a formula in Scratch.B1 =IF(Scratch.A1="A",1,0), or =IF(Prop.Letter="A",1,0), Scratch.B1 always shows 1, even though the value of A1 is changing to either be A or something else. How can I correctly use the result of the Prop.Letter selection as a valid value in another cell's formula? I like playing with VBA, but I would prefer that this be a shapesheet formula as it will be a master which will be used in numerous projects.

***Update: I just discovered the STRSAME() function and now it works the way I need it to. I don't really understand though why "A" on one cell does not equal "A" in another cell.