|Posted by:||Mike McLellan|
|Date:||Thu, 11 May 2006|
I am trying to use VLOOKUP to use a lookup value B5 to access an array to
return the value in column 2 of an array in another workbook. The expression
is as follows:
My problem is that, although looking at the values in B5 and Temp!B5 they
look identical, for some reason VLOOKUP is not recognising this. Also, if I
try =IF((B5=Temp!B7),"OK","Not OK") it comes up with 'Not OK'. Furthermore,
if I print out the ASCII character code for each character in each of the
strings, they are identical.
Can anyone help?