PDA

View Full Version : Excel Function question



19-01-2001, 07:22 PM
I need to ask the question - Is this cell's data the same as the data in any of this range?
For example, is B2 equal to anything in D3:D10? I need this in an IF function, something like...
=IF(B2=(J2:J8),'Yes','No')
except B2=(J2:J8) just compares B2 to J2
Any thoughts would be magic!