Formula needed to match two columns on two spreadsheets and return a third

I have two excel spreadsheets where I need to match the service location and bring back the merchandise amount for each month. I have attached a spreadsheet with an example of what I'm trying to match up in a formula.

Thanks for the help!

I have a solution - I think - but I have a few questions....

In your example, in column A Sheet 1 you have Service Locations and none of them match what's in Service location for Sheet 2....Next, on Sheet 2 in column E, you have 2 number 1's and so if the match worked it would only return the 1st match, which Merchandise amount would you want returned?.....does this make sense.....but the way I used INDEX/MATCH and an Array formula....

then try this

={INDEX($F$14:$F$20,MATCH(A3&F2,$A$14:$A$20&$E$14:$E$20,0))}

notice the {} this is an array formula....basically enter the formula in without the {} and then DON'T hit Enter....do Ctrl-Shift-Enter and then drag to the other cells....because your data isn't accurate I can't verify this....but give it a shot....

cool....glad I could help....and thanks for the rep points