Formula at intersection

[lehigh]

Hi All

I have a "Contractor / Work Type" spread sheet.

Starting w / A2, I have a contractor name column
Starting w / B2, I have a contractor work type column

Each cell in column B may look like the following;

A, B, E, S, T, X

or

T, V, W

or

M

(note: all of the codes will reside in the same cell, seperated with
a comma and a space)

Starting in C1 I have a row starting with A B C D
etc........These codes will be one to a cell.

I would like to write a fomula at the itersecting cells to show if any
of the codes in row 1 are contained in any of the cells in column B


Thanks for your help

Tom Snyder

 

[Frank Kabel]

Hi
in C2 enter
=IF(ISNUMBER(FIND(C$1,$B2)),"X","")
and copy this formula

 

[lehigh]

THANKS FRANK!

It works great