R

#### Raghavendran

I am using Microsoft Excel 2004 for mac version 11.3.5

I encounter strange problem of LOOKUP returning incorrect results. Following

is the simplified version of data and the problem.

TRUE A A

FALSE P R

FALSE F N

FALSE C D

TRUE C C

FALSE P Q

TRUE E E

TRUE G G

TRUE H H

TRUE I I

FALSE K L

TRUE K K

TRUE M M

FALSE E F

TRUE P P

TRUE S S

TRUE T T

TRUE W W

TRUE Y Y

FALSE T V

In column 3, you will find Data array.

column 2 is the result of the formula = =VLOOKUP($C3;$C$3:$C$22;1)

column 1 is the result of the formula = EXACT($B3;$C3)

The problem with VLOOKUP (also with LOOKUP, HLOOKUP) is it recognizes texts

R,N,D,Q,L,F,V as P,F,C,P,K,E,T respectively. The above misrecognition seems

to be only with the function LOOKUP as the function EXACT correctly

identifies mismatches in texts in column 2 and column 3 in the above example.

Any idea of the source and/or correction for the above problem with LOOKUP

function will be deeply appreciated.

regards

raghav

P.S : The problem is reproducable with Microsoft Excel 2002, Windows XP SP2.