Excel - VLOOKUP - TWO Variables

Asked By RJ on 12-Dec-07 01:52 AM
I can't tell if another post is the same question or not - I guess I'm that
stupid.

Here's what I got:

CLIENT         INDUSTRY       SALES PERSON        COUNTRY     Q1      Q2
Q3 etc



Want to have a VLOOKUP to make a table of CLIENT and INDUSTRY together.

In other words,

USA         AUTOMOBILE     TOTAL OF Q1+Q2+...+QN
USA         COMPUTERS     TOTAL OF Q1+Q2+...+QN
FRANCE   RETAIL                 TOTAL OF Q1+Q2+...+QN

How?

Thanks




Carim replied on 14-Dec-07 03:10 AM
Hi,

Why do not you try to use Data Pivot Table ... to have all the
flexibility needed ...

HTH
Bob Phillips replied on 12-Dec-07 04:00 AM
=INDEX(C1:C100,MATCH("USA"&"AUTOMOBILE",A1:A100&B1:B100,0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
RJ replied on 12-Dec-07 08:56 PM
The data is actually about 37 columns of stuff, and I'm trying to pull out
just a bit.

As to the below, I couldn't get it to work. What's the "C" column represent?
And can I substitue $A2 and $B2 for "USA" and "AUTOMOBILE"?
Bob Phillips replied on 13-Dec-07 03:29 AM
The represents where the data to retrieve is located. And yes, you can
substitute cells for the values.

--
HTH

Bob

(there is no email, no snail mail, but somewhere should be gmail in my addy)