A
Aris
Hi,
How do you search for data from a table having 2 criterias?
Example:
Month Name Score
Jan John 3
Jan Mark 2
Jan Tom 4
Feb John 5
Feb Mark 3
Feb Tom 4
Mar John 5
Mar Mark 4
Mar Tom 3
Let's say i want to look for the score for john in Feb. What formula could I
use?
Thank you,
How do you search for data from a table having 2 criterias?
Example:
Month Name Score
Jan John 3
Jan Mark 2
Jan Tom 4
Feb John 5
Feb Mark 3
Feb Tom 4
Mar John 5
Mar Mark 4
Mar Tom 3
Let's say i want to look for the score for john in Feb. What formula could I
use?
Thank you,