View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJB RJB is offline
external usenet poster
 
Posts: 86
Default 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