| 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, |
| 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 | |||
Threaded Mode
