Good afternoon everyone,
I thought I knew how to do this but seems not, I am trying to validate a cell value to see if it's in a name ranged and check if the cell above is the offset of the named ranged.
here is an example of what I have:
On sheet1 I have the following:
Cell C6 contain a...