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,...
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.
=IFERROR(IFERROR(VLOOKUP(NUMBERVALUE(B4),Data!A2:F100,2,FALSE),VLOOKUP(B4,Data!A2:F100,2,FALSE)),"")This formula seems to work. It checks if the numbervalue of the text in cell B4 is found in the Data sheet, then it checks if the textvalue from cell B4 is found in the Data sheet and otherwise it returns a blank cell.
Sorry, forgot to attach, here it is with the added part numbers.
The problem was the matrix of the VLOOKUP. I've adapted it from Data!A2:F100 to Data!A2:F200.
- Thank you, I should have caught that. I appreciate all of your help.
- Yes that works. I have added all of the part numbers I would like to have auto populate and some are in a letter format such as SOWH4 and those do not pull in. Sorry for that, but hope you have a solution for these as well. And that would be everything.
Thank you