Where column a and b matches col d and e then put the value of f in col c

Here's what I have, haven't used Excel in a while and need help

Col a Col b Col C Col d Col E Col F
Server1 DB1 Null Server2 DB1 100
Server1 DB2 Null Server2 DB2 80
Server 2 DB1 Null Server1 DB1 50
Server2 DB2 Null Server1 DB2 20


When col A and B match Col D and E, enter the value of col F in Col C

So this is what I would end up with

Col a Col b Col C Col d Col E Col F
Server1 DB1 50 Server2 DB1 100
Server1 DB2 20 Server2 DB2 80
Server 2 DB1 100 Server1 DB1 50
Server2 DB2 20 Server1 DB2 20

Hi & welcome to the board.
In C2 copied down

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Thanks for the welcome and the quick response!
It did give me what I needed, but now I realize I need a third column matched, so Col A and B, actually D and E and also F, the other col to match are K and L and M and then take the value of N and put it in col H
How would I add the third match?
Thanks in advance

If there will only ever be 1 match try this simpler formula

Formula:

Please Login or Register  to view this content.

You're welcome & thanks for the feedback