Hi guys, I'm trying to lookup a value in a cell against 2 columns and if it exists to return "exists" and if not "does not exist" but having much luck.
To try and clarifiy, below is what I'm trying to get to, where columnB returns the result:
ColumnA ColumnB ColumnD ColumnE
Jack Exists Nick Daniel
Michael Does not exist John Jack
Jenny Exists Jenny Bill
Peter Does not exist Lindy Luke
Paul Does not exist Sophie Sam