Hi,
I have a table with some duplicate values in various fields. I need to
extract a value from a certain row that answers to two different creterias:
Name Skill Score Active
1. John Craft 2 no
2. John Track 3 no
3. Dana Craft 7 yes
4. Dana Track 2 yes
In the example above I am trying to get the Score value where Skill =
"Craft" and Active = "yes"
VLOOKUP is obviously not good enough as it gets me the first Craft it
encounters without considering a second creteria.
How do I select from a table with two conditions at hand?
Bookmarks