Hi,
Try this:
=VLOOKUP(D2,'[07-0714 98th Percentile.xls]Port History'!$K$2:$K$2880,1,FALSE)
if you still get N/A your data is different hwever you see them the same for
example there maybe are some spaces behind or in front or a single quotention
if you send your data maybe i can find it.

Thanks,
--
Farhad Hodjat


"Janis" wrote:

I just want to see if there is a match in column D with another sheet called
Port History somewhere in column K. An exact match would be helpful. I put
this formula in the last column AN. I'm just getting a bunch of #n/a's.
There should be some matches. What am I doing wrong.


=LOOKUP(D2,'[07-0714 98th Percentile.xls]Port History'!$K$2:$K$2880,1)

TIA,