M
mgm36
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.
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.