Excel - VLOOKUP - TWO Variables

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

Hi,

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

HTH

=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)

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"?

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)