I am trying to use the lookup function, but excel is returning the wrong
result. My formula is LOOKUP(E53,AG1:AG55,AH1:AH55) where e53 is a value
inputted by the user. I want Excel to find the value in e5s in column ag and
grab the corrsponding data in column ah. it isnt finding the corrsponding
data in ah.