View Single Post
 
Old 04-22-2019, 12:16 PM
natelfo natelfo is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 6
natelfo is on a distinguished road
Default Shape Data - Using Fixed List selection in another cell's formula

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.
Reply With Quote