Comparing cells and copy/paste value if true. (Formula)

[OfficeUser]

Ok, so I will do my best to explain. I have Sheet 1 with data in columns E and F. I also have another Sheet 2 with data in columns in E and F. I want to compare both sheets and ensure that data in E/F cells on Sheets 1 match data in E/F cells on Sheet 2. If they are the same then I want to copy the value from the column AK cell, same row (Sheet 2), and copy it to Sheet 1, column T.

Example:

Row 25 - for example, plan it to copy formula from Row 2 to Row 200.
IF Sheet 1 Cell E = 2468, Cell F = Purple AND Sheet 2 Cell E = 2468, Cell F = Purple
THEN
Sheet 1 Cell T25 equals value found in Sheet 2 Cell AK25.

I have been struggling with this for many days and have tried many formulas. Some work in the Row 2 but when copied down mess up the output, or all match value in row 2. Anyone have some suggestions on how to accomplish this? I appreciate the help, and Happy Friday!!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what sort of values do you have in col AK?

 

[OfficeUser]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what sort of values do you have in col AK?

I am using Excel 2016 and have the ability to use Office365. The values in AK are dollar values. Thanks!

 

[Fluff]

Thanks for that. How about

=IFERROR(INDEX(Sheet2!$AK$2:$AK$1000,AGGREGATE(15,6,(ROW(Sheet2!$AK$2:$AK$1000)-ROW(Sheet2!$AK$2)+1)/(Sheet2!$E$2:$E$1000=E2)/(Sheet2!$F$2:$F$1000=F2),ROWS(T$2:T2))),"")