Excel - Lookup ? 1

[elfa]

Hello,

I have two sheets in the file.

Sheet One contains a list of numbers from cells A3 to A80.

Sheet Two has a number in cell A1 A3 A5 A7 going down the sheet.

Does the individual number in sheet two equal any of the numbers in the range from sheet 1? "Yes" "No"

I tried to write a formula but it did not work.

Kind Regards
Elfa

 

[KenWright]

Cell B1 on sheet2

=IF(MOD(ROW(),2)=0,"",IF(COUNTIF(Sheet1!$A$3:$A$80,Sheet2!A1)>=1,"Yes","No"))

Copy and paste down as far as needed. You can select all the cells in Col B and paste as it will only put data in the odd rows.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[KenWright]

Just for info, if the structure of your sheet changed at all such that the data ended up on the EVEN rows as opposed to the ODD rows, then you would need to alter the formula to

=IF(MOD(ROW(),2)=1,"",IF(COUNTIF(Sheet1!$A$3:$A$80,Sheet2!A1)>=1,"Yes","No"))

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------