How can I use vlookup to return "yes" or "no" answer using multiple tables?
How can I use vlookup to return "yes" or "no" answer using multiple tables?
Consider using the AND() or (OR() functions to concatenate results from separate VLOOKUPs, like
=IF(AND(VLOOKUP(1)=""Yes", VLOOKUP(2)="Yes", VLOOKUP(3)="Yes"),"Yes", "No")
There might be a big difference between your question and one that aims at the best method for your particular problem. The above answers your question without looking at the task.