ExcelBanter - To select from a list

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

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

- - To select from a list (https://www.excelbanter.com/excel-discussion-misc-queries/140137-select-list.html)

anil

To select from a list

Hi all

I have a cell "A1" where i am giving my values and have an column "B"
of data, i want to check the entered data in the first cell is present
in the Data column , and if so 2 to be displayed in "C1"else
""(null),...

Thanks and Regards
Anil.Hungund

JMay

To select from a list

in c1 enter:

=IF(COUNTIF(B:B,$A$1)0,2,"")

"anil" wrote in message
ups.com:

Hi all

I have a cell "A1" where i am giving my values and have an column "B"
of data, i want to check the entered data in the first cell is present
in the Data column , and if so 2 to be displayed in "C1"else
""(null),...

Thanks and Regards
Anil.Hungund

All times are GMT +1. The time now is 03:03 AM.