The workbook shows fixed locations. I want to tie cell to base record. So when the database record changes, the cell will display correct info.
What you can do is create a Query with only this field as result and insert it calc (drag from base to calc cell). It can be updated in Menu/Data/Refresh range.
When i do this it puts field name and data taking up two rows.
Why not putting it in another sheet and use a formula to reference to it.
Ok, did it, The formula works. Nested if statements. Now how can I change background color based on contents of cell from “database” sheet.
I have If statements to grab names from different columns based on certain conditions. That works fine. I was hoping to add 4 colors based on which of four words were in another column on sheet.