Lookup a value based on two keys

  • Thread starter Thread starter yakimoto
  • Start date Start date
Y

yakimoto

How can I get a string value from a table, based on criteria from tw
keys?
I couldn't find how to return a text
Example data:
Name Date Product-X Product-Y
John 1-1-2004 widget 0
John 2-1-2004 gadget 0
Pete 10-1-2004 chair 1

I need to answer: "What is the Product-X sold by John" and the answe
should
be "widget"
i.e.
=func(John,1-1-2004)
Result: widget
Is there any function doing that?

Using SUMPRODUCT I can calculate the number of sold product and sum o
sold product.
It seems I need some function as LOOKUP, but with two keys

Any suggestions
 
Yakimo,

Sorry I didn't follow up in the other thread. Seems to me that you could
use Autofilter and filter on John in the Name column. A pivot table might
be also work.

hth,

Doug
 
Back
Top