Vlook up with two refereces

[loufreixas]

I have a table with 5 columns
date country business sales receivables

I would like to select sales just for some countries for come months in another worksheet

So i use vlookup. The thing is that i would need to enter two references: country and month, and when i enter the formula =VLOOKUP(AND(A2;b2);AR!A2:E29;5), N/A appears.

Can somebody help me?
Thanks

 

[Banker1]

Your best bet would be to insert a column in the tab containing the data and concatenate the Country and Month (i.e. A2&B2). Once that's done your vlookup would look as follows:

=VLOOKUP(A2&B2,AR!A2:E29,5,0)

Hope that helps.

 

[jss1234]

Try:

=SUMPRODUCT((A2:A29="December"),(B2:B29="USA"),--(D2:D29))

Where A2:A29 contains Months, and B2:B29 contains Counties, and D2:D29 contains the Sales info.