| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP works in some cells but not others.
Excel 2000
Really simple data sheet: list of names with homerooms Lookup table: list of homerooms with teachers. (named "Range") =VLOOKUP(E2,Range,2) Some of the cells return the correct name, others #N/A. As far as I can tell they are all formatted exactly the same; I've tried several different formatting options. The correct ones stay the same; the no data ones do not change either. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
| getting data from cells in wrksheet & importing in existing works | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Threaded Mode
