(Solved) – Cell Reference not working for a formula in Excel


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.

Leave a Reply

Your email address will not be published. Required fields are marked *