Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup only finds #n/a's
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup only finds #n/a's
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup only finds #n/a's
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) "Farhad" wrote: 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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup only finds #n/a's
meanwhile I will try your formula also.
"Farhad" wrote: 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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup only finds #n/a's
You are right there are some commas missing on one of the columns. thanks,
"Farhad" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup finds first match | Excel Discussion (Misc queries) | |||
Excel finds a value that is not in the lookup range | Excel Worksheet Functions | |||
How do I create a formula in Excel that finds the value of the la. | Excel Worksheet Functions | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Which @function finds the mean of a number? | Excel Worksheet Functions |