I have two worksheets. The first is the MASTER. On the second worksheet I
want to have formula that if two cells in column A and B match then insert
information from C of the MASTER to the second worksheet. I can get one
match formula but can't get the second match.
Example: MASTER
A B C
40 502 5
50 407 2

worksheet2
A B C D
40 502 10
50 502 12

I need the formula to insert C information from the MASTER to worksheet2 D
but only if A and B match.
Hope this makes sense to someone.
What I have so far is one match formula
=INDEX(MASTER!B:B,MATCH(A4,MASTER!A:A,0))
Thanks for your help.