LOOKUP type formulas aren't case-sensitive. If you have a VLOOKUP like
=VLOOKUP(A1,B1:C10,2,0)
you could replace with this
=INDEX(C1:C10,MATCH(1,--EXACT(A1,B1:B10),0))
which need to be confirmed with CTRL+SHIFT+ENTER
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=557596