how do I show a value = a value in a range (A1 = any(b1:b35)?

's Computer Specifications

's Computer Specifications

Hi!

=ISNUMBER(MATCH(A1,B1:B35,0))

Or:

=COUNTIF(B1:B35,A1)>0

Biff

"Mike W" <Mike (E-Mail Removed)> wrote in message
news:6298A617-B63F-4EB8-B6F4-(E-Mail Removed)...
> how do I show a value = a value in a range (A1 = any(b1:b35)?

's Computer Specifications

Hi there

This array might work

=IF(OR(A1=B1:B35),"No found","No not found")

Use ctrl + shift + enter to use the array

VBA Noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56125

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show in another cell only >0 from a range?	RJJ	Microsoft Excel Worksheet Functions	0	11th May 2009 10:38 AM
Show Data In Range not appearing in Separate Range	=?Utf-8?B?QnJlbnQgRQ==?=	Microsoft Excel Misc	3	30th Apr 2007 09:32 PM
Show only Print_area range	Gwen	Microsoft Excel Programming	1	4th May 2006 07:47 AM
Report in date range to show each day in range	patricia	Microsoft Access Reports	1	13th Mar 2004 08:28 AM
Show one range in a combobox and write the 2nd range!	Kevin	Microsoft Excel Programming	1	17th Oct 2003 05:52 AM