R
Rick Jimenez
I am having a problem where I am using the VLOOKUP
function to populate a description of a part number from a
table. After verifying the equation is correct and that
the part number is in the table, the response is still
#n/a. At one point, I had to re-enter the part number
manually for it to recognize it and populate it
correctly.The formats of the cells are the same. The
lookup table is in Ascending order,and both part numbers
were re-entered manually. I do not understand why the
equation will not work correctly. Within the same table,
other part numbers were found and populated correctly with
the correct descriptions. Any ideas as to what is wrong
with either the equation or the part number format it is
looking for?
function to populate a description of a part number from a
table. After verifying the equation is correct and that
the part number is in the table, the response is still
#n/a. At one point, I had to re-enter the part number
manually for it to recognize it and populate it
correctly.The formats of the cells are the same. The
lookup table is in Ascending order,and both part numbers
were re-entered manually. I do not understand why the
equation will not work correctly. Within the same table,
other part numbers were found and populated correctly with
the correct descriptions. Any ideas as to what is wrong
with either the equation or the part number format it is
looking for?