Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'# N/A" result in V-Lookup
I have a table of data, in rows and columns, let's call it "Data Table".
I have a second table (let's call "Report Table") that I need to add info from from the "Data Table", so I am using a V-Lookup. Both tables are appropriately sorted for V-Lookup purposes, and I am using the "FALSE" desgination in the formula, requiring an exact match. The key field being used for searching is an ID number, however even if an ID number is exactly the same in both the Report Table and the Data Table, the V-Lookup is not returning the appropriate result; rather, I am getting '#N/A" as the result FOR MANY of the items in the Report Table, BUT NOT ALL, which is why I find this strange... For some of the V-Lookups, the output is proper, so I thought the format of the cells in certain "ID number" cells was different than others (e.g. maybe a character vs. a numeral), but the Report Table is a system-generated report every month, the cells are not manually populated. Any thoughts on why I might be getting "#N/A" for the majority of my outputs? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
A "IF" result that will not result in a selected field when using | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |