I need to lookup the values in sheet 1 column A where the corresponding value
in column c = "302" I don't want it to grab any values that are blank or not
equal to 302. can someone help? i'd like to list these in column A of sheet 2