Vlookup Case sensitive

OOPS! I copied the wrong formula...(sorry)
Try this

B1: =IF(ISNUMBER(MATCH(1,INDEX(--EXACT(A1,
Sheet2!$A$1:$A$6),0),0)),INDEX(Sheet2!$B$1:$B$6,MATCH(1,
INDEX(--EXACT(A1,Sheet2!$A$1:$A$6),0),0)),"No Match")

Actually....this formula is a bit shorter
(and still doesn't involve array entering...C+S+E)

B1: =IF(COUNT(INDEX(1/EXACT(A1,Sheet2!$A$1:$A$6),0)),
INDEX(Sheet2!$B$1:$B$6,MATCH(1,INDEX(--EXACT(A1,
Sheet2!$A$1:$A$6),0),0)),"no match")

Better?