Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | name | SKILLA | SKILLB | SKILLC | SKILLD | SKILLE | SKILLF | ||||
2 | AAA | 1 | 4 | 2 | 1 | 1 | 1 | ||||
3 | BBB | 5 | 5 | 3 | 5 | 5 | 5 | ||||
4 | CCC | 2 | 2 | 1 | 2 | 2 | 2 | ||||
5 | DDD | 4 | 1 | 4 | 4 | 4 | 4 | ||||
6 | EEE | 3 | 3 | 6 | 3 | 3 | 3 | ||||
7 | FFF | 7 | 8 | 7 | 7 | 7 | 7 | Skill | SKILLC | ||
8 | GGG | 6 | 6 | 5 | 6 | 6 | 6 | RANK | 2 | ||
9 | HHH | 9 | 9 | 9 | 9 | 9 | 9 | Name | #N/A | ||
10 | III | 8 | 7 | 8 | 8 | 8 | 8 | ||||
Sheet1 |
What am I doing wrong?
B1-G1 is named range'skill'
I7 is a drop down list for user to select Skill,
I8 is for user (me) to select skill level ie 2
When these criteria are met I9 should give me a name!!
not #N/A.
If somebody can educate me into my error/s, much appreciation from me.
Thanks
Steve