Giganews Newsgroups
Subject: VLOOKUP
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?