Timeline for Return value by lookup from multiple value
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 20, 2022 at 0:30 | comment | added | David Tan |
the error is saying that there is WHEREB somewhere in the function, though that seems strange since there is a space in the string. If you are able to provide a copy of your gsheet, that would help immensely. @TamásHéjja
|
|
| Jun 19, 2022 at 17:24 | comment | added | Tamás Héjja | Dear David, thank you for your reply! Unfortunately something is still missing from the formula, the following #VALUE error occurs: "Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered "<ID "WHEREB" at line 1, column 10. Was expecting one of: <EOF> "where" ... "group" ... "pivot" ... "order" ... "skipping" ... "limit" ... "offset" ... "label"... "format"... "options" "," ... "*" ... "+" ... "-" ... "/" ... "%" ... "+" ... "-" ... Can you please help me with what else to add to the query? | |
| Jun 19, 2022 at 17:12 | comment | added | Tamás Héjja | Dear David, thank you for your reply! Unfortunately something is still missing from the formula | |
| Jun 17, 2022 at 16:16 | history | answered | David Tan | CC BY-SA 4.0 |