VLOOKUP

  • Thread starter Thread starter JAN
  • Start date Start date
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

HTH
Jason
Atlanta, GA
 
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
Click to expand...
...

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP 2
Vlookups not working 2
Dynamic col_index_num in VLOOKUP? 5
vlookup formatting problem 1
Vlookup in 2007 is now case sensitive 5
Need VLOOKUP to Work Two Ways 0
Excel IF statement with vlookup 2
Case Sensitivity in Lookup Functions 4

Back
Top