Forum Discussion
maddjohn1985
Sep 09, 2024Copper Contributor
I want to make a cell equal a value based on the value in a list
I'm making a template where I want a cell to populate with a value depending on what value has been selected from a list. Example Cell A1 has list Red Yellow Orange Pink Blue If R...
Lorenzo
Sep 09, 2024Silver Contributor
Setup a table (named TableColorValue above) with the desired VALUE by COLOR. In A4 assuming you run 2021/365:
=IF(ISBLANK(A1), "", XLOOKUP(A1, TableColorValue[COLOR], TableColorValue[VALUE]))