Case Sensitive Vlookup-How?

Originally Posted by Haseeb A

Hello Alfred, another way,

LOOKUP(2,1/EXACT(A2,J$2:J$5),K$2:K$5)

copy down.

works really well