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,