Vlookup using mutiple tables

0

How can I use vlookup to return "yes" or "no" answer using multiple tables?

Answer
Discuss

Answers

0

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.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login