I am using a formula =DARTSCRDE|StrikePrice!’2045033_0′ works fine. But i want the code which in this case is 2045033 to be a cell value, that i can change as per my need.
So, I want a formula like =DARTSCRDE|StrikePrice!’& A1 &”_0′”. But this does not work. Any help on this?
Also tried “DARTSCRDE|StrikePrice!'” & A1 & “_0′” but did not work as well
PS: Adding underscore is mandatory.