VLOOKUP *is* non-case sensitive. If I look up "cat", I'll
get a hit for any of these:
CAT
CaT
Cat
caT
cAt
cat
CAt
cAT
...
So your work-around would be . . . ?
As always, when VLOOKUP proves inadequate, use INDEX/MATCH, but this time with a
twist. With the lookup table named Tbl, and the result desired in it's N_th
column, try the array formula
=INDEX(Tbl,MATCH(TRUE,EXACT(INDEX(Tbl,0,1),"cat"),0),N)
