I created a name range as shown below (formatted as a table), but when I created a VLOOKUP formula on another sheet, to grab the ranks, all worked but the BC rank. (kept getting #NA) I tested to ensure the criteria matched (by using =RANKS!A3='Master Staff List'!F14) , and i get a TRUE, so I know the text matches.
The ONLY way i was able to get it to correctly work is to insert a blank row above BC in my name range. Does anyone know why that would be?
The ONLY way i was able to get it to correctly work is to insert a blank row above BC in my name range. Does anyone know why that would be?
| Rank | Service Bar | Braid | Shoulder Flash |
| BC | Gold | Two Gold | Gold |
| CAPT | Silver | Two Silver | Silver |
| CFPO | Gold | Two Gold | Gold |
| CHIEF | Gold | Five Gold | Gold |
| CTO | Gold | Two Gold | Gold |
| DC | Gold | Four Gold | Gold |
| EVT | Silver | N/A | Silver |
| FF | Silver | N/A | Silver |
| FLSE | Silver | N/A | Silver |
| FPO | Silver | One Silver | Silver |
| Recruit | N/A | N/A | N/A |
