Vlook up with two refereces

loufreixas

New Member
Joined
Dec 16, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
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

Active Member
Joined
May 28, 2004
Messages
434
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,009
Members
412,304
Latest member
citrus
Top