Hello everyone

Does anyone know how I could enter a function into a cell that would reference a part number with a list of parts on another sheet and return a specific value (a letter) if it is on the this. I think it would have to be a combination of a vlookup and an "if" function, but everytime i try it doesn't work.