Fairly new to this, hoping you guys/gals can help, struggling to work out how to do this.
I want to look for a value in a column using multiple criteria and if it exists the do something if not do something else.
For example, does the value "XYZ" exist in column C where the value in column B is 01/01/2019 and the value in column A is 12345, if yes then say 'complete' otherwise lookup an alternative value using vlookup.
Hope that makes some sense to someone and appreciate the feedback.
Bookmarks