Please help me ...

Exhumes

Board Regular
Joined
Jun 4, 2006
Messages
63
i ned formula if i have Number exist in Column B to seek in Column C1:C300 if there is similar to the number it gives me True if not it will answer me False
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,837
Office Version
  1. 365
Platform
  1. Windows
Exhumes

Is this what you mean?
=ISNUMBER(MATCH(B1,$C$1:$C$300,0))
 

Watch MrExcel Video

Forum statistics

Threads
1,113,992
Messages
5,545,373
Members
410,679
Latest member
rolandbianco
Top