VLOOKUP

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:

=VLOOKUP(B5,Temp!B5:D643,2,FALSE)

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?

Replies