Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
3

Your formula is correct. You just need to use single ' instead of double " quotes. =INDEX('Value Reference'!B2:AJ6,MATCH(B4,'Value Reference'!A2:A6,0),MATCH(B5,'Value Reference'!B1:AJ1,0)) EDIT Make Data validation dynamic You can improve your results even further. Instead of using List of items for your Data validation, you can use List from a range. ...


1

You are trying to associate a "text value " in a data validation cell with a given numerical value. One supposes that this is so that you can use the numerical value in another formula. It is common practice in forms for each select item to have a description AND a separate "value", unfortunately Google Sheets does not offer this. The cell that you use for ...


1

Try this in 'Main Sheet'!B6: =query(transpose(query('Value Reference'!A1:AJ7,"Select * where A = '"&'Main Sheet'!B4&"'",-1)),"SELECT Col2 where Col1 = '"&'Main Sheet'!B5&"'",0) 2nd Solution : =QUERY(TRANSPOSE('Value Reference'!B1:AJ7), "SELECT Col"&filter(ArrayFormula(IF('Main sheet'!B4='Value Reference'!A2:A7,ROW('Value ...


1

Google Sheets data validation only helps to prevent wrong in-cell data entering. You could use a custom formula to handle conditions but any editor could remove the data validation it could not directly prevent other actions, like disallow the "form submission". As you already using buttons we could assume that you are using Google Apps Script. You could ...


1

Use regular expressions and REGEXMATCH I think that =REGEXMATCH(A1,"^\[.*]$") should work.


1

As I can see you need a report about all cells with data validation rules. The next code creates the sheet with name 'dataValidation report' into the active spreadsheet and puts a little report to there. function genDataValidationReport() { var res = Sheets.Spreadsheets.get(SpreadsheetApp.getActive().getId(), { fields: 'sheets(properties(title),data(...


Only top voted, non community-wiki answers of a minimum length are eligible