On 2002-08-27 17:41, ROKK wrote:
How can you perform a vlookup with multiple variables?
i.e. I need to look up department and year and return a unique amount for both criteria.
The dataset will have department and year in their respective columns more than once.
On 2002-08-28 08:41, ROKK wrote:
Dept. Year Amount
Accounting 1997 36.76
Accounting 1998 48.97
Operations 1997 56.98
If I wanted to perform a vlookup to return the amount for Accounting in 1997?