Formula for matching three columns and returning result from nth column

Julesdude

Board Regular
Joined
Jan 24, 2010
Messages
196
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

Well-known Member
Joined
Oct 5, 2015
Messages
801
Office Version
2007
Platform
Windows
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,"")
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top