A sort of lookup or match

L

lehigh46

Hi All

The following alpha/numeric codes are "work type codes". 84 in all.
These codes reside in cells J1 through CO1

A B C C1 C2 C5 C6 C4 D
E F F1 F2 F3 F4 G G1 G2
G3

G4 W B1 C3 H H1 H2 J J1
J2 K K1 K2 L M M1 M2 M3
N

N1 O O1 O2 O3 P P1 P2 P3
P4 P5 P6 P7 P8 Q Q1 R R1
S

S0 S1 S2 S3 S4 S5 S6 S7 S8
S9 T T1 T3 T4 T5 T6 T7 T8
T9

U U1 V V1 V2 X Z ZZ


Column B contains contractors names. (About 400)
Column D contains the codes listed below.

The following codes are associated with a specific contractor in
column D and reside in the same cell.

B, B1, C1, C3, H, H1, H2, K, K1, K2, M2

The example above showes 11 codes. A contractor may have only one code
or a contractor may have all 84 codes. All codes are followed by a
comma and a space with the exception of the last code.


I want to write a formula at the intersections of the codes in row 1
and column D that will yield a charactor or a number if any of the 84
codes at the top match any of the codes contained in the cell for each
contractor.

I hope I explained this correctly


Thanks for any help you can give me.

Tom Snyder







x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD
 
R

RagDyer

If I understand what you're looking for, try this in J2:

=IF(ISNUMBER(SEARCH(J$1,$D2)),"X","")

Drag across and down to copy as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi All

The following alpha/numeric codes are "work type codes". 84 in all.
These codes reside in cells J1 through CO1

A B C C1 C2 C5 C6 C4 D
E F F1 F2 F3 F4 G G1 G2
G3

G4 W B1 C3 H H1 H2 J J1
J2 K K1 K2 L M M1 M2 M3
N

N1 O O1 O2 O3 P P1 P2 P3
P4 P5 P6 P7 P8 Q Q1 R R1
S

S0 S1 S2 S3 S4 S5 S6 S7 S8
S9 T T1 T3 T4 T5 T6 T7 T8
T9

U U1 V V1 V2 X Z ZZ


Column B contains contractors names. (About 400)
Column D contains the codes listed below.

The following codes are associated with a specific contractor in
column D and reside in the same cell.

B, B1, C1, C3, H, H1, H2, K, K1, K2, M2

The example above showes 11 codes. A contractor may have only one code
or a contractor may have all 84 codes. All codes are followed by a
comma and a space with the exception of the last code.


I want to write a formula at the intersections of the codes in row 1
and column D that will yield a charactor or a number if any of the 84
codes at the top match any of the codes contained in the cell for each
contractor.

I hope I explained this correctly


Thanks for any help you can give me.

Tom Snyder







x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top