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 don't 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)

"RJB" wrote in message
...
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

Why don't you try to use Data Pivot Table
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" wrote:

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

"RJB" wrote in message
...
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

The represents where the data to retrieve is located. And yes, you can
substitute cells for the values.

--
HTH

Bob

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

"RJB" wrote in message
...
Why don't you try to use Data Pivot Table
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" wrote:

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

"RJB" wrote in message
...
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