Lookup table using 2 entries to lookup a value....
Posted by Chris Rock on November 15, 2001 11:26 AM
I have a 3 column table with the following data: TIME, PRODUCT, and CALLS.
What I'd like to do, in cell G2, is get the number of CALLS for a particular PRODUCT (typed in F2) at a particular TIME (typed in E2).
Does this require an array formula? Can someone share with me how this works?
A VLookup won't do the trick, because it's only looking up on ONE criteria. This needs to lookup on 2 criteria.