I am really struggling with this and have looked on numerous sites including this one and what i am trying to achieve I do not think I am alone.
Simply put I want to check two separate cell on the same line to see if they match- check if a cell has one value or other and if so shown text
- next if it does not match check a different cell for a match, if so show text if not
- show a drop down list from a named range
I have tried the following in both the cell directly or via data validation list and none give the desired result. Either I get an error with no suggestions, a blank cell or the drop down list even when the first criteria are met
I am sure there will be question so please ask! thanks in advance and stay safe!
Bookmarks