I have a spreadsheet with a cell containing a numeric value in Cell C30. If
the cell value matches a value from a list of numeric values in Sheet 2, I
would then have cell c31.value ="Yes". If not I would leave it as "No",
Is there a macro that would do just this.

Thanks

--
Message posted via http://www.officekb.com