Matching numeric values.

[mohd21uk via OfficeKB.com]

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

 

[Guest]

in C31 enter:

=IF(ISNA(MATCH(C30,Sheet2!A1:A30,0)),"No","Yes")