vlookup?

Column A is a list of names.
Column B has the letter D if employee is working day shift, blank if not.

How can I produce a list of names in column C that are working day shift?

Thanks for any help on this!

Hi Sable,

You do not need to apply Vlookup. You can simply use the following formulae in Column C,

"=IF(B1 = "D", A1, "")"

Hope this helps.

Regards,
Vaibhav