I, for the life of me, cannot figure out why this isn't returning what I want, nor why it is returning what it is.
I am trying to get a table to tell me whether a position if offense or defense. While I know what it really is, this table is part of a bigger "program" if you will.
The Index Match version:
Index-Match Help.JPG
I have no idea why it will not return "Offense" when putting in WR (or QB, RB, TE).The red text is the value it is returning. Regardless of position I enter. Except for DE. If you put in DE, it'll return the result "N/A".
Here is the VLookup version:
Vlookup Help.JPG
Don't know why it's not returning any value there either.
Any help would be much appreciated!
Bookmarks