Given the following formula:=dget(Sheet2!$A:$C,Sheet2!B$1,{USER ID;$A2})Is there a way to alter this formula so that it fills all the values in a column? I've tried with arrayformula, changing $A2 for $A2:$A, but I can't make it work .
Extending dget to a column in Google Spreadsheet
google spreadsheets;formulas
I would use VLOOKUP instead of DGET; it has simpler syntax and works with ARRAYFORMULA. Example: Sheet2 columns A and B+---------+-------+| User Id | Name  |+---------+-------+|    4444 | Grace ||    1111 | Jon   ||    2222 | Tim   |+---------+-------+Another sheet has numbers 1111, 2222, 4444, 2222 in cells A2-A5. Entering in B2 the formula =ARRAYFORMULA(VLOOKUP(A2:A5,Sheet2!A:B,2,FALSE))will fill out the table+------+-------+| 1111 | Jon   || 2222 | Tim   || 4444 | Grace || 2222 | Tim   |+------+-------+But you probably want =ARRAYFORMULA(VLOOKUP(A2:A,Sheet2!A:B,2,FALSE)) to avoid specifying the end row. As written, this will work but will produce a bunch of #N/A errors in empty rows, because VLOOKUP fails when given an empty string as a key. These can be suppressed with IFERROR: change B2 to =ARRAYFORMULA(IFERROR(VLOOKUP(A2:A,Sheet2!A:B,2,FALSE)))