Data Lookup and Validation

[sd8]

Excel Workbook
	A	E	F	G	J	K	L	M	N	O
1	BOM	Item Num	Qty	UM	*	1050-110-ENG	1050-240-XXX	51794-00	52021-00	52736-02
2	1050-110-ENG	50900-00	0	EA	*	*	*	*	*	*
3	1050-110-ENG	T1121-00	0	EA	*	*	*	*	*	*
4	1050-110-ENG	89806-50	1	EA	*	*	*	*	*	*
5	1050-240-XXX	50900-00	0	EA	*	*	*	*	*	*
6	1050-240-XXX	T1121-00	0	EA	*	*	*	*	*	*
7	1050-240-XXX	T0443-00	1	EA	*	*	*	*	*	*
8	1050-240-XXX	T1173-00	1	EA	*	*	*	*	*	*
9	1050-240-XXX	53071-00	1	EA	*	*	*	*	*	*
10	1050-240-XXX	T0582-00	1	EA	*	*	*	*	*	*
11	1050-240-XXX	10893-00	1	EA	*	*	*	*	*	*
12	1050-240-XXX	52007-00	1	EA	*	*	*	*	*	*
13	1050-240-XXX	T0584-00	1	EA	*	*	*	*	*	*
14	1050-240-XXX	51048-00	5	Ft	*	*	*	*	*	*
15	1050-240-XXX	48741-00	1	EA	*	*	*	*	*	*
16	1050-240-XXX	48998-03	1	EA	*	*	*	*	*	*
17	1050-240-XXX	10564-00	5	Ft	*	*	*	*	*	*
18	1050-240-XXX	104587-00	2	EA	*	*	*	*	*	*
19	1050-240-XXX	48998-04	1	EA	*	*	*	*	*	*
20	1050-240-XXX	107275-00	1	EA	*	*	*	*	*	*
21	51794-00	MI51794-00	0	*	*	*	*	*	*	*
22	51794-00	51789-02	1	EA	*	*	*	*	*	*
23	51794-00	51790-02	1	EA	*	*	*	*	*	*
24	51794-00	51793-00	3	EA	*	*	*	*	*	*
25	51794-00	52032-03	3	EA	*	*	*	*	*	*
26	51794-00	09206-64	3	EA	*	*	*	*	*	*
27	51794-00	10425-00	0.001	EA	*	*	*	*	*	*
28	51794-00	10421-00	0.001	EA	*	*	*	*	*	*
29	52021-00	19300-06	1	EA	*	*	*	*	*	*
30	52021-00	06299-26	1	EA	*	*	*	*	*	*
31	52021-00	37255-00	1	EA	*	*	*	*	*	*
32	52021-00	07084-00	0.001	Lbs	*	*	*	*	*	*
33	52736-02	52736-XX	0	EA	*	*	*	*	*	*
34	52736-02	MI52736-XX	0	*	*	*	*	*	*	*
35	52736-02	T0200-00	1	EA	*	*	*	*	*	*
36	52736-02	52737-02	1	EA	*	*	*	*	*	*
37	52736-02	T0180-00	1	EA	*	*	*	*	*	*
38	52736-02	62314-103	2	EA	*	*	*	*	*	*
39	52736-02	10422-00	0.00001	EA	*	*	*	*	*	*
40	52736-02	10425-00	0.00001	EA	*	*	*	*	*	*
41	52736-02	38522-00	0.0625	Ft	*	*	*	*	*	*
42	52736-02	T0116-02	0.00001	EA	*	*	*	*	*	*
43	52736-02	56111-001	2	EA	*	*	*	*	*	*
below is a portion of a sheet i am trying to search and identify duplicates... ex. if a part number in column E exists for a given assy in column A, I want to identify it in the corresponding column K-O with an "X or 1 or the P/N itself" Sheet1

 

[Sahak]

Hi sd8,

How I understand you need formulas:

K2 =IF(AND(ISERROR(MATCH($E2,$A:$A,0))=FALSE,$E2=$K$1),"X","*")
L2 =IF(AND(ISERROR(MATCH($E2,$A:$A,0))=FALSE,$E2=$L$1),"X","*")
M2 =IF(AND(ISERROR(MATCH($E2,$A:$A,0))=FALSE,$E2=$M$1),"X","*")
N2 =IF(AND(ISERROR(MATCH($E2,$A:$A,0))=FALSE,$E2=$N$1),"X","*")
O2 =IF(AND(ISERROR(MATCH($E2,$A:$A,0))=FALSE,$E2=$O$1),"X","*")

And copy down