Google Apps spreadsheet indirect sheet name? -
i have google apps spreadsheet 3 sheets, y2013, y2014, , table.
on table sheet want place contents of cell b2 either y2013 or y2014 depending upon in contents of cell a1 on table i.e., a1 either y2013 or y2014.
i have tried: =a1!b2 ='&a1&'!b2.
what else might try?
you can use indirect dynamically refer sheetnames in example:
=indirect(concatenate(a1;"!b2")) call a1 should contain year number (y2013 or y2014).
if want learn more on how use indirect can check this: http://spreadsheetpro.net/how-to-make-a-dynamic-reference-to-a-worksheet-in-excel-and-google-spreadsheets/
Comments
Post a Comment