Index match with multiple criteria(different than usual)

T

Thiago Correia

Worksheet1
A B C D
1 4 5 6
2 7 8
3 9


Worksheet2
A B
6 1
9 3
7 2


The result in Worksheet2!B should be the value of worksheet1!A if worksheet1!B or worksheet1!C or worksheet1!D contains the same value of Worksheet2!A


I tried to use VLOOKUP AND INDEX MATCH functions, but I couldn't find any answer.

If anybody could help me on this formula I would appreciate it.

Thanks in advance,
Thiago
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index match with multiple criteria(different than usual) 3
Vlookup Multiple Criteria - Please help 1
matching 2 worksheets to find differences 2
count cells with multiple criteria and two rows 2
SumIf with multiple Criteria 6
Sort a coloum on one worksheet according to another coloumn on ano 0
Sort one coloumn according to another coloumn on another worksheet 0
Retuyrning a single entry when multiples of the same 3

Top