ExcelBanter - Matching numeric values.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matching numeric values. (https://www.excelbanter.com/excel-discussion-misc-queries/89073-matching-numeric-values.html)

mohd21uk via OfficeKB.com

Matching numeric values.

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

Gary''s Student

Matching numeric values.

in C31 enter:

=IF(ISNA(MATCH(C30,Sheet2!A1:A30,0)),"No","Yes")
--
Gary's Student

"mohd21uk via OfficeKB.com" wrote:

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

All times are GMT +1. The time now is 08:18 PM.