Advanced Vlookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi

I have a spreadsheet which has customer names and data about them such
as country name , state name and city name. It also has details about
type of purchases made.

In another spreadsheet i want to call certain other data about the
customer using the filter criteria. But i dont want to use auto
filters.

In cell a1 of this second spreadsheet i type the country/state/town
name.
In cell b1 of this second spreadsheet i type the type of purchase. Now
these purchase types also have sub classifications. E.g Electronic
gadgets can be a classififcation and dvd player , cell phones etc can
be sub classifications. i can also require to check customers for all
classifications taken together or sum of all.

Now what i want is that suppose i type country India in cell a1 and
type electronic gadgets in cell a2 , excel should return in a4 - a"x"
all customers who have purchased electronic gadgets in india. Now if i
want to narrow down the search lets say i type bangalore in a1 and cell
phones in a2 it should return the names of customers from bangalore
(which is a sub-sub classififcation in country india and state
karnataka) who have purchased mobile phones (which is a sub
classification in electronic gadgets ) in a4 -a"x".

I will use the names of these customers in a4 -a"x" to further extract
data from other locations.Hope i have made myself clear.

Thanks in advance

Manan


--
manan
------------------------------------------------------------------------
manan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34216
View this thread: http://www.excelforum.com/showthread.php?threadid=545439

.

Relevant Pages

  • Re: n. stiff, the antonym?
    ... and were not at the mercy of the generosity of the customers. ... your country. ... custom should be changed for the benefit of foreign visitors. ...
    (alt.usage.english)
  • Re: n. stiff, the antonym?
    ... and were not at the mercy of the generosity of the customers. ... your country. ... custom should be changed for the benefit of foreign visitors. ...
    (alt.usage.english)
  • Re: How would I remove all data from northwinds template.
    ... there can be any question that Northwind's Customers table is not adequately ... country a natural key could be used. ... Northwind would be made up of City, Region and Country columns, and Regions ... proper normalization can be found in its Customers table. ...
    (microsoft.public.access.gettingstarted)
  • Re: Advanced Vlookup
    ... In cell b1 of this second spreadsheet i type the type of purchase. ... these purchase types also have sub classifications. ... all customers who have purchased electronic gadgets in india. ...
    (microsoft.public.excel)
  • Re: Standing up to criminals?
    ... I once saw some CCTV footage from a "kebab" shop. ... customers in the shop stand and watch or look away like its not their ... don;t understand why the people of this country allow the scum bags to get ... worry them one jot. ...
    (uk.legal)