ExcelBanter - Validation in IF string

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Validation in IF string (https://www.excelbanter.com/excel-worksheet-functions/194219-validation-if-string.html)

papajoe

Validation in IF string

Does anyone know how to include a LIST (Validation) in an If string?

e.g. =if (J12="M"; "N.A"; LIST["Pool balance"; "Account balance"])

i.e. if J12 not equal to M then I would like the user to chose between "pool
balance" and "accountr balance"

/ J

All times are GMT +1. The time now is 05:47 PM.