Hello,
I'm sorry if this question has been asked already but I've been looking for an answer for a while to no avail.
I would like to know how to lookup multiple values using multiple criteria. Let us say that in column A are last names, in column B are first names, and in column C are phone numbers. In this list, a person's name may occur many times since one person may have many phone numbers.
A B C
Smith Ben 12345
Smith Ben 67890
Smith Sarah 09876
Andrews Maria 54321
Andrews Maria 11223
Johns Teresa 99876
Lookup: Ben Smith's numbers?
I know how to use index match to find one value using multiple criteria, but can't find multiple values using multiple criteria.
I am using MS Excel 2010.
Thanks in advance for your help!!
R
I'm sorry if this question has been asked already but I've been looking for an answer for a while to no avail.
I would like to know how to lookup multiple values using multiple criteria. Let us say that in column A are last names, in column B are first names, and in column C are phone numbers. In this list, a person's name may occur many times since one person may have many phone numbers.
A B C
Smith Ben 12345
Smith Ben 67890
Smith Sarah 09876
Andrews Maria 54321
Andrews Maria 11223
Johns Teresa 99876
Lookup: Ben Smith's numbers?
I know how to use index match to find one value using multiple criteria, but can't find multiple values using multiple criteria.
I am using MS Excel 2010.
Thanks in advance for your help!!
R