Intersection Formula

[lehigh46]

Hi All:

I have a "Contractor / Work Type" sheet

In column A starting in cell A2 I have contractors names

In column B starting in cell B2 I have groupings of work types.
These groupings may look like the following;

A, B, D, S, Y (note: these are all in the same cell) (all are
seperated by a comma and a space)

or

S, V, W

or

E

Now, in row 1 starting with C1, Ii have work types A B C D E and so
on.
Each of these codes has it's own cell.

What formula can I write that will find one code (Row 1) in a
grouping of many (Column B) and give me a result of 1 if I find a
match at the intersection any cell in Column B and Row 1



Thank You Very Much for Your Help


Tom Snyder

 

[ross]

I think you need this

=IF(C2 <>"",IF(FIND(C2,B2,1) >0, 1,0),"")

will put one if therrs a match, and #VALUE! if there is not