Author Topic: Shape Data - Using Fixed List selection in another cell  (Read 164 times)

0 Members and 1 Guest are viewing this topic.


  • Newbie
  • *
  • Posts: 6
Shape Data - Using Fixed List selection in another cell
« on: April 22, 2019, 01:13:54 PM »
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.
« Last Edit: April 22, 2019, 03:17:53 PM by natelfo »