R Ravindra Member Feb 11, 2016 #1 Dear All, I need to get value through passing reference from another sheet. Please help, kindly find the attached file. Attachments Test_Excel.xlsx 10.7 KB · Views: 3
Dear All, I need to get value through passing reference from another sheet. Please help, kindly find the attached file.
N NARAYANK991 Excel Ninja Feb 11, 2016 #2 Hi Ravindra , I don't know why you want to do this , but you can try : =INDIRECT("Sheet1" & "!" & A3) Enter this in B3 , and copy down. Narayan
Hi Ravindra , I don't know why you want to do this , but you can try : =INDIRECT("Sheet1" & "!" & A3) Enter this in B3 , and copy down. Narayan
