OK, so I’m going cross eyed trying to figure this out. It seems so obvious or common that it would be everywhere, but I’m clearly not finding it. Please help if you can.
I have two excel sheets, the first sheet has a bunch of data and in particular one column that has part numbers. The second sheet has columns each with heading that that describes the part numbers, like a column called “Washers” with the list of part numbers below of all the washers and so on. For a total of 5 categories.
I’d like to have a formula or script for a blank column to the first sheet that automatically compares the part number in the first column with the data in the second sheet and populates the category, e.g. “washers”. I’d like to be able to add and subtract to the second sheet as the part numbers change or get deleted. I would also like the logic to say “N/A” or something similar if it can’t find a matching category.
Thanks in advance!
I have two excel sheets, the first sheet has a bunch of data and in particular one column that has part numbers. The second sheet has columns each with heading that that describes the part numbers, like a column called “Washers” with the list of part numbers below of all the washers and so on. For a total of 5 categories.
I’d like to have a formula or script for a blank column to the first sheet that automatically compares the part number in the first column with the data in the second sheet and populates the category, e.g. “washers”. I’d like to be able to add and subtract to the second sheet as the part numbers change or get deleted. I would also like the logic to say “N/A” or something similar if it can’t find a matching category.
Thanks in advance!