lookup only finds #n/a's

lookup only finds #n/a's

Post by SmFuaX » Sat, 28 Jul 2007 06:02:01


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,
 
 
 

lookup only finds #n/a's

Post by RmFyaGF » Sat, 28 Jul 2007 06:34:03

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

 
 
 

lookup only finds #n/a's

Post by SmFuaX » Sat, 28 Jul 2007 06:48:00

FArhad:
This is killing me these lookups I have to turn these sheets into a db. To
make it simpler I tried a lookup instead of a vlookup since there is only
one column for the lookup table. I don't know what the vectorResult should
be???

I am in an active sheet column AN:2 doing this lookup. At least that is
where I want the results to go in each cell in column AN I will have the same
formula. In this column I just want a 1 or 0 whether the lookup hit a match.
So I want to lookup on this active sheet the match column is D2 and I want to
match it with the column K on the Port History sheet. I am getting all
#n/a's in column AN where I have my formula. Can you please help me again.
I have too much trouble with vlookup.

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

lookup only finds #n/a's

Post by SmFuaX » Sat, 28 Jul 2007 06:48:01

meanwhile I will try your formula also.
 
 
 

lookup only finds #n/a's

Post by SmFuaX » Sat, 28 Jul 2007 07:02:03

You are right there are some commas missing on one of the columns. thanks,