I have a lookup table like the one below (2 columns, 9 rows)
Age Group Category
04 - 06, Baseball
07 - 08 Boys, Baseball
07 - 08 Girls, Softball
09 - 10 Boys, Baseball
09 - 10 Girls, Softball
11 - 12 Boys, Baseball
11 - 12 Girls, Softball
13 - 14 Boys, Baseball
15 - 16 Boys, Baseball
I have a VLOOKUP formula that uses this table to check a value in a cell to see what age group is present and then puts the category in the data results.
The problem is that for some reason it wants to put 11 - 12 Girls as Baseball...this is the only one that acts this way...
Anyone have any ideas?
Here is the formula:
=VLOOKUP(P2,league,2), where league is the named range.
Thank you in advance
Bob
Age Group Category
04 - 06, Baseball
07 - 08 Boys, Baseball
07 - 08 Girls, Softball
09 - 10 Boys, Baseball
09 - 10 Girls, Softball
11 - 12 Boys, Baseball
11 - 12 Girls, Softball
13 - 14 Boys, Baseball
15 - 16 Boys, Baseball
I have a VLOOKUP formula that uses this table to check a value in a cell to see what age group is present and then puts the category in the data results.
The problem is that for some reason it wants to put 11 - 12 Girls as Baseball...this is the only one that acts this way...
Anyone have any ideas?
Here is the formula:
=VLOOKUP(P2,league,2), where league is the named range.
Thank you in advance
Bob