Hi there,

I'm trying to find out if there is a worksheet function that can check
if a value exists in a cell, where that cell may contain multiple
values.

My example, is with resources. I am exporting resources from calendar
to excel - so the 'required attendees' field may have up to 15 or so
unique values (names) in each cell, seperated by a ';'.

I have developed code that will basically split each name into it's own
cell - but this is a messy way to do things.

I'm thinking there must be a way in excel to return a TRUE/FALSE (or
similar) on whether a value exists in a cell containing multiple
values.

eg. A1 may contain -

Smith, John; Stewart, James; Jones, Elizabeth

I'm chasing a function that does -

IF A1 -CONTAINS- 'Stewart, James' THEN A2=TRUE, ELSE A2 = FALSE.

Or something along those lines.

If someone can point me to a function or example I would be grateful!

Cheers

Rob


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=494313