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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angie - 15 May 2008 16:17 GMT

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

Reply to this Message

Jerry Whittle - 15 May 2008 17:23 GMT

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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.
[quoted text clipped - 12 lines]
> Asia Cosmetics $XX $XX $XX
> Asia Analgesics $XX $XX $XX

Reply to this Message

Angie - 15 May 2008 18:21 GMT

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

> VlookUp is an Excel function. Access uses DLookUp. Are you working in Excel
> or Access? If Excel, you have the wrong forums.
[quoted text clipped - 15 lines]
> > Asia Cosmetics $XX $XX $XX
> > Asia Analgesics $XX $XX $XX

Reply to this Message