I want to write a formula to return one of 2 cell values
I have 3 cells in play here. Cell 1 is a formula pulling a value from "Grid A". Cell 2 is pulling a value from "Grid B". There is typically either going to be a value in cell 1 OR a value in cell 2, which means one of those 2 cells likely says "NO MATCH". How can I teach column 3 to pull in the value for the cell that does not say "NO MATCH". I've tried this with no luck (simplified the cell names for this post):
Help Article Resources
Check out the Formula Handbook template!