OK, I have a list created as a data validation list for people to fill in
blanks within a spreadsheet. List is below with the corresponding values for
each label:

ABSENT 0
CONCEPTUAL 1
APPLIED 2
EXPERT 3
INNOVATOR 4

I am using a formula to pull in the value associated with the label to a
selected cell. The formula is (assume the table is in A6:B10):

=IF(ISNA(VLOOKUP(F6,A6:B10,2)),"N/A",VLOOKUP(F6,A6:B10,2))

All works well except for the "Conceptual" selection pulls a "2" instead of
a "1". All the other selections work fine. Can someone explain this and
show me a fix?

thanks,
Scott