Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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