QUESTION

I am trying to develop a formula in a cell where I can search an entire column for a particular part number. If the formula finds the number, I want a "Y" put in the cell, if it doesn't find the number, I want a "NOT FOUND" put in the cell.

ANSWER

It looks like VLOOKUP is the function to use to handle this problem.