Formula for matching three columns and returning result from nth column

[Julesdude]

Hi there,

I am looking for a formula to do the following:

Return the value in column AE if column A value matches a value in column D AND column B matched a value in column C AND column F matched value in column G. Basically I want to find the row that matches 3 values and return something from column x of that same row.

How do I do this?

Thanks

Julian

 

[jmacleary]

Hi there.
This formula will return the contents of column AE only if all 3 of your criteria match, which I think is what you want. Put it in whichever column you want the result. Hope so anyway. =IF(AND(A1=D1,B1=C1,F1=G1),AE1,"")