Hi, im working on a sheet where i need to verify whether two columns fullfill a criteria from a table, i use this formula:
=IFERROR(IF(AND(VLOOKUP([@[From zone]];Tabel5;1;FALSE)=[@[From zone]];VLOOKUP([@[To zone]];Tabel5;1;FALSE)=[@[To zone]]);[@[Value 2]];"");0)
However as i need to verify...