Try the below test scenario using INDEX() and MATCH()

ColA ColB ColC ColD
One 1 ONE =formula
one 2
ONE 3

Formula in D1
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

=INDEX(B1:B10,MATCH(TRUE,EXACT(C1,A1:A10),0))


If this post helps click Yes
---------------
Jacob Skaria


"Mliamos" wrote:

I was wondering if there is a way to make the cells in Excell case sensitve,
so when your using look up functions it only returns the cell with the
correct upper and lowercase letters