how to use excel indirect function in c#

Question

Can u tell me how to use the formula =INDIRECT(A2) in c#
This function is working in excel but not working in c# any idea plz help me

 Excel.Range vehicle_makes_dropdown = xlWorkSheet1.get_Range("B2", "B101");

            string formula1 = "=INDIRECT(A2)";

            vehicle_makes_dropdown.Validation.Add(Excel.XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertInformation, XlFormatConditionOperator.xlEqual, formula1, misValue);

            vehicle_makes_dropdown.Validation.IgnoreBlank = true;

            vehicle_makes_dropdown.Validation.InCellDropdown = true;