Google Product Forums
Re: Update corresponding column of master spreadsheet based on other spreadsheet cell data
MarinusP May 22, 2012 10:25 AM
Posted in group: Google Docs

Categories: Sheets : Ask a "how-to" question : Mobile device (specify device type/OS) :

Hi

I guess you forgot the function IF. Instead of:

=ARRAYFORMULA((TRANSPOSE(FILTER('Form Master'!B:T; 'Form Master'!A:A=MAX('Form Master'!A:A)))=G1:K1;G1:K1;))

please try:

=ARRAYFORMULA(IF(TRANSPOSE(FILTER('Form Master'!B:T, 'Form Master'!A:A=MAX('Form Master'!A:A)))=G1:K1,G1:K1,))