Certain words from two different cells need to match to get total

[thanhie]

Hi I'm not sure if I'm putting this down correctly or if I even make sense. But here goes.

In the attachment, column P of worksheet titled "2016 AOP", should equal the number in column F of the worksheet titled "2015 actuals" if two conditions are met. Condition 1) the 1st four characters of column A worksheet "2015 actuals" must match the 1st four characters of column A worksheet "2016 AOP". Condition 2) the 1st three characters of column B worksheet "2015 actuals" must match column C worksheet "2016 AOP".

[MarvinP]

Hi thanhie,

I created two "helper" columns, one on each sheet and then did this problem using an Index Match combination. To do the "if conditions are met" part was a simple IfError function. Here it is:

=IFERROR(INDEX('2015 Actuals'!$F$1:$F$57,MATCH(V2,'2015 Actuals'!$K$1:$K$57,0)),"")

See the attached for the answer.