Hi,
I'm having some sort of trouble with the compatibility of formula between excel and Google sheet,i made an spread sheet and
i have uploaded it to the Google drive,
Below formula works perfectly well on spreadsheet,when i add a workbook named "1" it would catch up the data without any fuss,but google
sheet doesn't do so,any solutions..
I could manually copy and paste the formulas in the google sheet and it is giving result,i'm looking for another solution
=IFERROR(INDIRECT("'1'!$L"&ROW($L10)),0)
Thanks,
Ak
Bookmarks