What kind of values are you looking up, if you want exact match you SHOULD
use FALSE or 0 at the end of the formula, if you are looking up numeric
values that you want to return largest value that is less than or equal to
lookup then do not use FALSE, otherwise use it. If you get an error then the
values are not equal, they could be imported with leading/trailing spaces
that will be enough
Compare 2 values that you think are the same

=A1=A6

if that returns false theye are not equal


Regards,

Peo Sjoblom

"Tina M" wrote:


I have a vlookup formula put in place to look at column M (a year), find
the matching year in column A on a different tab and return the value in
column B =VLOOKUP(M6,'ENR Index'!A:B,2)
Very simple formula.

The problem is - after the 6th line on the worksheet, the formula
returns a value of N/A.
I have sorted the sheet a number of different ways, but continue to
receive the same fomula in the 6th line.
I have entered False and True in the the formula but still come up with
nothing.


Can anyone assist with this?
Thank you


--
Tina M
------------------------------------------------------------------------
Tina M's Profile: http://www.excelforum.com/member.php...o&userid=24017
View this thread: http://www.excelforum.com/showthread...hreadid=376358