Question # 1 is:

I have a list of agents helping in selling multiple products. One sheet
consists of Two columns i.e. Name & Item and on the other sheet only a single
column of Names. Here, on this second sheet, I want to place a VLOOKUP sort
of formula in front of each name of agent so as to reflect the product he is
MOST involved in.

For example the source may be as:

Agent 1 Product A
Agent 1 Product B
Agent 1 Product B
Agent 1 Product B

Now if I place a VLOOKUP in front of Agent 1 in the other sheet only the
first match would result, i.e. Product A whereas concentration in Product B
is found.

Another similar question is:

Agent 1 Product A 10,000
Agent 1 Product B 20,000

How to insert a VLOOKUP sort of formula for showing Product B in front of
Agent 1 because volumne of sales of Product B is greater than that of Product
A.

--

Best Regards,
FARAZ A. QURESHI