Finding multiple values in a data range

[Excel_noob_]

Quick explanation of what I'm trying for:

I have a data table with sales data (part #'s, item descriptions, dates, prices, etc.).
I would like to set up an additional 3 columns (columns U, V and W):
1) one asking if customer contact is required that I want to auto-fill based on the part number that is entered. (more about this in a minute)
2) one that gives a date 30 days after the ship date if the answer in column 1 is yes, and na if no.
3) one that gives the date that contact was made to the customer (this will be filled in by another employee manually). This column will be conditionally formatted to turn red if the due date is missed.

The issue I'm having is with item 1 and 2. The part number is what will determine if customer contact is required. The issue is I need to account for all the different part numbers that can prompt a Yes response. How do I account for a range of possible part numbers to trigger the yes? Is this a match function? Do I need to make a separate list in another sheet with those part numbers? Or is there a way to type in each variable manually?
Item 2, what would the formula look like to display ship date (lets say cell M30)+30 if item 1 is a yes, and na if blank?

Help please~! I'm out of my depth on this one.

[xwarlock10x]

can you upload a sample.. ??

[ascool_asice]

Hi I have attached a excel sheet let me know if this is what you were looking for... also if you upload your sheet it would be easier

Cheers

[Excel_noob_]

In this part of your formula, VLOOKUP(A2,'req part numbers'!$A$1:$B$10,2,0)=0, what do those 0's mean? The usual entry at the end of a vlookup would be true or false. What does a 0 mean? And what is that last =0 do?

[ascool_asice]

In this part of your formula, VLOOKUP(A2,'req part numbers'!$A$1:$B$10,2,0)=0, what do those 0's mean? The usual entry at the end of a vlookup would be true or false. What does a 0 mean? And what is that last =0 do?

The 0 inside the vlookup stands for true, If it were 1 it would mean false

Vlookup usually returns a 0 for blank cells, so what we are telling vlookup is that if the cell in the lookup range is blank then let the cell value be blank else return a yes