If TL;DR - Just go down to the EDIT...
I have a spreadsheet with a table - the table is a comparison of two different (but similar) sets of data. So basically 3 columns with the 3rd being the result column with the formula:
I would like a 4th column that would hold the contents of
[@[column_name]] if the result column
[@[column_result]] is TRUE, but if the result is FALSE, default it to blank, but some how allow the end user a way that they can populate it with
[@[column_name]] if they want. Or of course they could always manually enter something.
This spreadsheet is going to be used repeatedly, it's more of a template, so the data and row counts will change every time - that's why it's all in a table.
I've thought about maybe having a dynamically generated drop down list that defaults to colmn_name if TRUE and blank if FALSE, but I'm not sure how to do that. Or maybe a button in the cell if Result is false, that when clicked, disappears and populates the cell with column_name...
Additional Info: The spreadsheet is basically comparing the fields from two SQL tables and highlighting the differences (there are far more than 3-4 columns, but for the sake of this question, I dumbed it down). Eventually the data from tableA needs to be mapped to tableB, so I'm using excel to write and format the bulk of the SQL. There are many tables and many fields that need to be compared.
Also, sorry if this question sucks... I know it does, but I don't really know how to best ask it.
Below is a picture of my spreadsheet. Column M will = column A if columns E-H are true in other words:
IF(colsE-H == TRUE) ColM = ColA; ELSE ColM = ""; If there isn't a value in M then the user needs to do some manual investigating, if everything checks out (usually does), then the user will copy/paste A into M. I would like to have like a dropdown or a button or something that would allow Col M to be populated with Col A's value at the click (two clicks?) of a mouse.
EDIT2: That pic got shrunk a lot. Here is a link: Screenshot