How to use vlookup when you have 2 or more criteria to meet

A

Angie

I have a huge database with the sales of different product lines and regions
and I need to extract the key lines by region for the corresponding period.
vLookup is just bringing the first "world" in the database so if I want to
have the value for world for "cosmetics" as well as world for "analgesics".
I'm not a heavy excell user....so I guess I have to combine to functionshow
can I do it?? HELP!!!!!

Column #
1 2 3 4 5
Prior Year Budget Actual
World Cosmetics $XX $XX $XX
World Analgesics $XX $XX $XX
Europe Cosmetics $XX $XX $XX
Europe Analgesics $XX $XX $XX
Asia Cosmetics $XX $XX $XX
Asia Analgesics $XX $XX $XX
 
J

Jerry Whittle

VlookUp is an Excel function. Access uses DLookUp. Are you working in Excel
or Access? If Excel, you have the wrong forums.
 
A

Angie

Sorry....indeed.. I'm in the wrong forum.

Jerry Whittle said:
VlookUp is an Excel function. Access uses DLookUp. Are you working in Excel
or Access? If Excel, you have the wrong forums.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup when have 2 or more criteria to meet 5
How to input line break in the body of an email defined in vb. 1
A Pivot Table challenge--I can't do it, can you? 5
VLOOKUP to ignore lines which do not meet criteria 1
How to DISPLAY all data values in Pivot Table...not count, sum, etc 3
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
VLookup with 2 criteria 6
VLOOKUP or SUMIF for Multiple Criteria 2

Top