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

  • Thread starter Thread starter Angie
  • Start date Start date
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
 
VlookUp is an Excel function. Access uses DLookUp. Are you working in Excel
or Access? If Excel, you have the wrong forums.
 
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 make a database out of this 4
Rosters and adding hours linked to a persons name 11
Vlookup, Index or Match - Problem 2
Vlookup, Index or Match - Problem 1
Filling in a grid of text boxes using nested loops? 1
Extracting Unicode characters from RTF 1
More advanced question - how to form subroutines or classes which Ican use on several forms 25

Back
Top