If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Looking up values in a table
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, |
Thread Tools | |
Display Modes | |
|
|