Forum Discussion
Auto populate different cells based on one cells value and not have VLOOKUP return #N?A if value not
I am trying to have cells B6, B8 and B10 auto populate from the Data tab based on B4's input value. If the number in B4 matches what is in Data in column A, return the values, but if it is not found,...
The Part # in cell B4 was entered as text. I changed it to number format and your formulas return the intended result.
I forgot to mention that we have some part numbers that start with a zero and if it is not text, it will not find or show the correct part number in cell B4.