How to look up same lot and show in another column

[afc171]

Hi all,

I want to be able to look up product code(s) in J3 from the range A-G, but since there could be the same product multiple times how do I show all the lots in J or another column?

At the moment if I enter one product it will only pick the first one in the column B.

LCStock.xlsm
	A	B	C	D	E	F	G	H		J	K	L	M	N	O
1	warehouse	product	description	lot_number	bin_number	quantity	date_received			product	description	lot_number	bin_number	quantity	date_received
2	LC	100 VIAL BOX	100 VIAL BOX	280319		5	28/Mar/2019				#N/A	#N/A	#N/A	#N/A	#N/A
3	LC	100 VIAL BOX	100 VIAL BOX	290419		8	29/Apr/2019
4	LC	12004271	ZE5 Additive	1220L420	LC16	1	25/Aug/2021
5	LC	12004271	ZE5 Additive	0521L510	LC16	2	09/Sep/2021
6	LC	12004272	Cytometer Cleaner	64405351	LC16	2	21/Sep/2021
7	LC	12004403	ZE Series QC Bead	BR010517C	LCPRO401	1	02/Sep/2020
8	LC	12004403	ZE Series QC Bead	01M-122120	LCPRO401	2	05/Oct/2021
9	LC	1351114	VIVAFIX 398/550	2361222	LCLAB201	2	24/Sep/2021
10	LC	1351118	VIVAFIX 649/660	2680021	LCLAB201	1	24/Sep/2021
11	LC	1351118	VIVAFIX 649/660	2610052	LCLAB201	1	19/Oct/2021
12	LC	1450016	COUNTING SLIDES	210305	ELABRT	5	07/Oct/2021
13	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	1	03/Aug/2021
14	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	3	14/Sep/2021
15	LC	1610396	UNSTAINED PROTEIN	64359194	LCLAB201	1	10/Mar/2021
16	LC	1610610	DITHIOTHREITOL (DTT)	64367890	LCLAB28	1	16/Jun/2021
17	LC	1610610	DITHIOTHREITOL (DTT)		LCLAB28	2	09/Sep/2021
18	LC	1610737	LAEMMLI SAMPLE BUFF	64394236	LC16	2	12/Apr/2021
19	LC	1610747	LAEMMLI SAMPLE BUFF	64388927	LC16	2	29/Mar/2021
20	LC	1610772	TGS (10x)	64394630	LC17	1	17/Mar/2021
21	LC	1610782	TBS 1% CASEIN BLOCKI	64406796	LCLAB28	2	02/Jul/2021
22	LC	1610782	TBS 1% CASEIN BLOCKI	64422511	LCLAB28	1	10/Sep/2021
23	LC	1704157	PVDF TRANSBLOT	64416630	LCLAB28	3	14/Sep/2021
24	LC	1704159	MIDI NITROCELLULOSE	64376912	LCLAB28	2	10/Mar/2021
25	LC	1705061	CLARITY WESTERN ECL	102031588	LC16	3	10/Mar/2021
26	LC	1705061	CLARITY WESTERN ECL	102031562	LC16	1	24/Mar/2021
27	LC	20X30	20X30 BAGS 250g		LC	3	17/Aug/2017
28	LC	30389292	USE DIS0008	2119,22327	LC7	1	02/Jul/2021
29	LC	30389292	USE DIS0008	2126,31543	LC7	1	27/Jul/2021
30	LC	5678084	CRITERION 4-15% TGX	64424017	LCLAB28	19	25/Aug/2021
31	LC	5678084	CRITERION 4-15% TGX	64427926	LCLAB28	21	05/Oct/2021
32	LC	5678124	ANY KD CRITERION TGX	64414906	LCLAB28	10	29/Jun/2021
33	LC	5678124	ANY KD CRITERION TGX	64429406	LCLAB28	47	05/Oct/2021
34	LC	5678124	ANY KD CRITERION TGX	64422769	LCLAB28	53	05/Oct/2021
35	LC	ANI0001	16206F BALB/cOlaHsd	170322AWO	ELABRT	2	08/Apr/2021
36	LC	ANI0001	16206F BALB/cOlaHsd	170875NCO	ELABRT	2	12/Jul/2021
37	LC	ANI0001	16206F BALB/cOlaHsd	090921	ELABRT	2	16/Sep/2021
38	LC	ANI0001	16206F BALB/cOlaHsd	210921	ELABRT	2	01/Oct/2021
39	LC	ANI0002	16206M BALB/C6-8	171063NCO	ELABRT	2	12/Aug/2021
40	LC	ANI0004	1702M LEW/SsNHsd RAT	171063NCO	ELABRT	2	12/Aug/2021
41	LC	ANI0004	1702M LEW/SsNHsd RAT	290921	ELABRT	4	29/Sep/2021
42	LC	ANI0006	1704M 4-6 WK RATS	170322AWO	ELABRT	2	08/Apr/2021
43	LC	ANI0006	1704M 4-6 WK RATS	170875NCO	ELABRT	10	12/Jul/2021
44	LC	ANI0006	1704M 4-6 WK RATS	171063NCO	ELABRT	6	12/Aug/2021
45	LC	ANI0015	5717F C57BL/6/cOla	151021	ELABRT	10	15/Oct/2021
46	LC	ANI0016	5717M C57BL/6/Jola	170770NCO	ELABRT	5	24/Jun/2021
47	LC	ANI0016	5717M C57BL/6/Jola	171063NCO	ELABRT	1	12/Aug/2021
48	LC	ANI0017	LARGE CONTAINER	170770NCO	ELABRT	1	24/Jun/2021
49	LC	ANI0017	LARGE CONTAINER	170875NCO	ELABRT	1	12/Jul/2021
50	LC	ANI0017	LARGE CONTAINER	151021	ELABRT	1	15/Oct/2021
51	LC	ANI0018	SMALL CONTAINER	170322AWO	ELABRT	3	08/Apr/2021
52	LC	ANI0018	SMALL CONTAINER	170875NCO	ELABRT	2	12/Jul/2021
53	LC	ANI0018	SMALL CONTAINER	171063NCO	ELABRT	4	12/Aug/2021
54	LC	ANI0018	SMALL CONTAINER	090921	ELABRT	1	16/Sep/2021
55	LC	ANI0018	SMALL CONTAINER	290921	ELABRT	1	29/Sep/2021
56	LC	ANI0018	SMALL CONTAINER	210921	ELABRT	1	01/Oct/2021
57	LC	BLO0001	BEAGLE BLOOD IN EDTA	A2081421	LC	1	05/Aug/2021
58	LC	CHE0006	MYCOALERT ASSAY	0001022992	LCLAB28	4	09/Sep/2021
59	LC	CHE0007	MYCOALERT + DET KIT	0072089342	LCLAB28	1	26/Apr/2021
60	LC	CHE0007	MYCOALERT + DET KIT	081021	LCLAB28	4	08/Oct/2021
61	LC	CHE0009	CONCANAVALIN A	SLCC7678	LCLAB201	1	27/Apr/2021
62	LC	CHE0011	A7906-500G BSA	SLCK4288	LCLAB28	3	21/Jul/2021
63	LC	CHE0012	IONOMYCIN	109M4048V	LCLAB28	1	27/Apr/2021
64	LC	CHE0013	PMA	SLBX8889	LCLAB201	1	27/Apr/2021
65	LC	CHE0014	SHEATH FLUID	2106809820	LC25	1	28/Apr/2021
66	LC	CHE0014	SHEATH FLUID	2119609817	LC25	3	27/Aug/2021
67	LC	CHE0015	PHA-P	SLCC9870	LCLAB28	1	27/Apr/2021
68	LC	CHE0016	FACS CLEAN SOLUTION	2101909812	LC10	1	28/Apr/2021
69	LC	CHE0016	FACS CLEAN SOLUTION	2118709823	LC10	3	13/Sep/2021
70	LC	CHE0020	HUMAN SERUM	SLBX6359	LCLAB201	1	27/Apr/2021
71	LC	CHE0020	HUMAN SERUM	SLCF0691	LCLAB201	2	09/Sep/2021
72	LC	CHE0021	BOVINE SERUM ADULT	20G024	LCLAB201	1	07/May/2021
73	LC	CHE0022	HARD SET DAPI	ZH0720	ELAB04	1	15/Sep/2021
74	LC	CHE0023	ACUITY ADVANCED	B339419	LCLAB28	2	24/May/2021
75	LC	CHE0024	CHROMOGEN CONCENTRAT	B333546	LCLAB28	1	25/Oct/2021
76	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	1	26/Apr/2021
77	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	2	25/Oct/2021
78	LC	CHE0028	TC GRADE DMSO	RNBK1495	LC22	1	06/May/2021
79	LC	CHE0028	TC GRADE DMSO	RNBK3905	LC22	2	21/Sep/2021
80	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	3	05/May/2021
81	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	8	20/Oct/2021
LC_Stock

Cell Formulas
Range	Formula
K2	K2	=VLOOKUP(J2,B:G,2,FALSE)
L2	L2	=VLOOKUP(J2,B:G,3,FALSE)
M2	M2	=VLOOKUP(J2,B:G,4,FALSE)
N2	N2	=VLOOKUP(J2,B:G,5,FALSE)
O2	O2	=VLOOKUP(J2,B:G,6,FALSE)

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	warehouse	product	description	lot_number	bin_number	quantity	date_received			product	description	lot_number	bin_number	quantity	date_received
2	LC	100 VIAL BOX	100 VIAL BOX	280319		5	28/03/2019			1351118	VIVAFIX 649/660	2680021	LCLAB201	1	24/09/2021
3	LC	100 VIAL BOX	100 VIAL BOX	290419		8	29/04/2019				VIVAFIX 649/660	2610052	LCLAB201	1	19/10/2021
4	LC	12004271	ZE5 Additive	1220L420	LC16	1	25/08/2021
5	LC	12004271	ZE5 Additive	0521L510	LC16	2	09/09/2021
6	LC	12004272	Cytometer Cleaner	64405351	LC16	2	21/09/2021
7	LC	12004403	ZE Series QC Bead	BR010517C	LCPRO401	1	02/09/2020
8	LC	12004403	ZE Series QC Bead	01M-122120	LCPRO401	2	05/10/2021
9	LC	1351114	VIVAFIX 398/550	2361222	LCLAB201	2	24/09/2021
10	LC	1351118	VIVAFIX 649/660	2680021	LCLAB201	1	24/09/2021
11	LC	1351118	VIVAFIX 649/660	2610052	LCLAB201	1	19/10/2021
12	LC	1450016	COUNTING SLIDES	210305	ELABRT	5	07/10/2021
13	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	1	03/08/2021
14	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	3	14/09/2021
15	LC	1610396	UNSTAINED PROTEIN	64359194	LCLAB201	1	10/03/2021
16	LC	1610610	DITHIOTHREITOL (DTT)	64367890	LCLAB28	1	16/06/2021
17	LC	1610610	DITHIOTHREITOL (DTT)		LCLAB28	2	09/09/2021
18	LC	1610737	LAEMMLI SAMPLE BUFF	64394236	LC16	2	12/04/2021
19	LC	1610747	LAEMMLI SAMPLE BUFF	64388927	LC16	2	29/03/2021
20	LC	1610772	TGS (10x)	64394630	LC17	1	17/03/2021
21	LC	1610782	TBS 1% CASEIN BLOCKI	64406796	LCLAB28	2	02/07/2021
22	LC	1610782	TBS 1% CASEIN BLOCKI	64422511	LCLAB28	1	10/09/2021
23	LC	1704157	PVDF TRANSBLOT	64416630	LCLAB28	3	14/09/2021
24	LC	1704159	MIDI NITROCELLULOSE	64376912	LCLAB28	2	10/03/2021
25	LC	1705061	CLARITY WESTERN ECL	102031588	LC16	3	10/03/2021
26	LC	1705061	CLARITY WESTERN ECL	102031562	LC16	1	24/03/2021
27	LC	20X30	20X30 BAGS 250g		LC	3	17/08/2017
28	LC	30389292	USE DIS0008	211,922,327	LC7	1	02/07/2021
29	LC	30389292	USE DIS0008	212,631,543	LC7	1	27/07/2021
30	LC	5678084	CRITERION 4-15% TGX	64424017	LCLAB28	19	25/08/2021
31	LC	5678084	CRITERION 4-15% TGX	64427926	LCLAB28	21	05/10/2021
32	LC	5678124	ANY KD CRITERION TGX	64414906	LCLAB28	10	29/06/2021
33	LC	5678124	ANY KD CRITERION TGX	64429406	LCLAB28	47	05/10/2021
34	LC	5678124	ANY KD CRITERION TGX	64422769	LCLAB28	53	05/10/2021
35	LC	ANI0001	16206F BALB/cOlaHsd	170322AWO	ELABRT	2	08/04/2021
36	LC	ANI0001	16206F BALB/cOlaHsd	170875NCO	ELABRT	2	12/07/2021
37	LC	ANI0001	16206F BALB/cOlaHsd	90921	ELABRT	2	16/09/2021
38	LC	ANI0001	16206F BALB/cOlaHsd	210921	ELABRT	2	01/10/2021
39	LC	ANI0002	16206M BALB/C6-8	171063NCO	ELABRT	2	12/08/2021
40	LC	ANI0004	1702M LEW/SsNHsd RAT	171063NCO	ELABRT	2	12/08/2021
41	LC	ANI0004	1702M LEW/SsNHsd RAT	290921	ELABRT	4	29/09/2021
42	LC	ANI0006	1704M 4-6 WK RATS	170322AWO	ELABRT	2	08/04/2021
43	LC	ANI0006	1704M 4-6 WK RATS	170875NCO	ELABRT	10	12/07/2021
44	LC	ANI0006	1704M 4-6 WK RATS	171063NCO	ELABRT	6	12/08/2021
45	LC	ANI0015	5717F C57BL/6/cOla	151021	ELABRT	10	15/10/2021
46	LC	ANI0016	5717M C57BL/6/Jola	170770NCO	ELABRT	5	24/06/2021
47	LC	ANI0016	5717M C57BL/6/Jola	171063NCO	ELABRT	1	12/08/2021
48	LC	ANI0017	LARGE CONTAINER	170770NCO	ELABRT	1	24/06/2021
49	LC	ANI0017	LARGE CONTAINER	170875NCO	ELABRT	1	12/07/2021
50	LC	ANI0017	LARGE CONTAINER	151021	ELABRT	1	15/10/2021
51	LC	ANI0018	SMALL CONTAINER	170322AWO	ELABRT	3	08/04/2021
52	LC	ANI0018	SMALL CONTAINER	170875NCO	ELABRT	2	12/07/2021
53	LC	ANI0018	SMALL CONTAINER	171063NCO	ELABRT	4	12/08/2021
54	LC	ANI0018	SMALL CONTAINER	90921	ELABRT	1	16/09/2021
55	LC	ANI0018	SMALL CONTAINER	290921	ELABRT	1	29/09/2021
56	LC	ANI0018	SMALL CONTAINER	210921	ELABRT	1	01/10/2021
57	LC	BLO0001	BEAGLE BLOOD IN EDTA	A2081421	LC	1	05/08/2021
58	LC	CHE0006	MYCOALERT ASSAY	1022992	LCLAB28	4	09/09/2021
59	LC	CHE0007	MYCOALERT + DET KIT	72089342	LCLAB28	1	26/04/2021
60	LC	CHE0007	MYCOALERT + DET KIT	81021	LCLAB28	4	08/10/2021
61	LC	CHE0009	CONCANAVALIN A	SLCC7678	LCLAB201	1	27/04/2021
62	LC	CHE0011	A7906-500G BSA	SLCK4288	LCLAB28	3	21/07/2021
63	LC	CHE0012	IONOMYCIN	109M4048V	LCLAB28	1	27/04/2021
64	LC	CHE0013	PMA	SLBX8889	LCLAB201	1	27/04/2021
65	LC	CHE0014	SHEATH FLUID	2106809820	LC25	1	28/04/2021
66	LC	CHE0014	SHEATH FLUID	2119609817	LC25	3	27/08/2021
67	LC	CHE0015	PHA-P	SLCC9870	LCLAB28	1	27/04/2021
68	LC	CHE0016	FACS CLEAN SOLUTION	2101909812	LC10	1	28/04/2021
69	LC	CHE0016	FACS CLEAN SOLUTION	2118709823	LC10	3	13/09/2021
70	LC	CHE0020	HUMAN SERUM	SLBX6359	LCLAB201	1	27/04/2021
71	LC	CHE0020	HUMAN SERUM	SLCF0691	LCLAB201	2	09/09/2021
72	LC	CHE0021	BOVINE SERUM ADULT	20G024	LCLAB201	1	07/05/2021
73	LC	CHE0022	HARD SET DAPI	ZH0720	ELAB04	1	15/09/2021
74	LC	CHE0023	ACUITY ADVANCED	B339419	LCLAB28	2	24/05/2021
75	LC	CHE0024	CHROMOGEN CONCENTRAT	B333546	LCLAB28	1	25/10/2021
76	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	1	26/04/2021
77	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	2	25/10/2021
78	LC	CHE0028	TC GRADE DMSO	RNBK1495	LC22	1	06/05/2021
79	LC	CHE0028	TC GRADE DMSO	RNBK3905	LC22	2	21/09/2021
80	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	3	05/05/2021
81	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	8	20/10/2021
82
Main

Cell Formulas
Range	Formula
K2:O7	K2	=IFERROR(INDEX(C$2:C$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/($B$2:$B$100=$J$2),ROWS(K$2:K2))),"")

 

[afc171]

I pasted the code into K2 but it doesn't seem to show anything when I enter a product in J2?

LCStockXL.xlsm
	A	B	C	D	E	F	G	H		J	K	L	M	N	O
1	warehouse	product	description	lot_number	bin_number	quantity	date_received			product	description	lot_number	bin_number	quantity	date_received
2	LC	100 VIAL BOX	100 VIAL BOX	280319		5	28/Mar/2019			30389292
3	LC	100 VIAL BOX	100 VIAL BOX	290419		8	29/Apr/2019
4	LC	12004271	ZE5 Additive	1220L420	LC16	1	25/Aug/2021
5	LC	12004271	ZE5 Additive	0521L510	LC16	2	09/Sep/2021
6	LC	12004272	Cytometer Cleaner	64405351	LC16	2	21/Sep/2021
7	LC	12004403	ZE Series QC Bead	BR010517C	LCPRO401	1	02/Sep/2020
8	LC	12004403	ZE Series QC Bead	01M-122120	LCPRO401	2	05/Oct/2021
9	LC	1351114	VIVAFIX 398/550	2361222	LCLAB201	2	24/Sep/2021
10	LC	1351118	VIVAFIX 649/660	2680021	LCLAB201	1	24/Sep/2021
11	LC	1351118	VIVAFIX 649/660	2610052	LCLAB201	1	19/Oct/2021
12	LC	1450016	COUNTING SLIDES	210305	ELABRT	5	07/Oct/2021
13	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	1	03/Aug/2021
14	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	3	14/Sep/2021
15	LC	1610396	UNSTAINED PROTEIN	64359194	LCLAB201	1	10/Mar/2021
16	LC	1610610	DITHIOTHREITOL (DTT)	64367890	LCLAB28	1	16/Jun/2021
17	LC	1610610	DITHIOTHREITOL (DTT)		LCLAB28	2	09/Sep/2021
18	LC	1610737	LAEMMLI SAMPLE BUFF	64394236	LC16	2	12/Apr/2021
19	LC	1610747	LAEMMLI SAMPLE BUFF	64388927	LC16	2	29/Mar/2021
20	LC	1610772	TGS (10x)	64394630	LC17	1	17/Mar/2021
21	LC	1610782	TBS 1% CASEIN BLOCKI	64406796	LCLAB28	2	02/Jul/2021
22	LC	1610782	TBS 1% CASEIN BLOCKI	64422511	LCLAB28	1	10/Sep/2021
23	LC	1704157	PVDF TRANSBLOT	64416630	LCLAB28	3	14/Sep/2021
24	LC	1704159	MIDI NITROCELLULOSE	64376912	LCLAB28	2	10/Mar/2021
25	LC	1705061	CLARITY WESTERN ECL	102031588	LC16	3	10/Mar/2021
26	LC	1705061	CLARITY WESTERN ECL	102031562	LC16	1	24/Mar/2021
27	LC	20X30	20X30 BAGS 250g		LC	3	17/Aug/2017
28	LC	30389292	USE DIS0008	2119,22327	LC7	1	02/Jul/2021
29	LC	30389292	USE DIS0008	2126,31543	LC7	1	27/Jul/2021
30	LC	5678084	CRITERION 4-15% TGX	64424017	LCLAB28	19	25/Aug/2021
31	LC	5678084	CRITERION 4-15% TGX	64427926	LCLAB28	21	05/Oct/2021
32	LC	5678124	ANY KD CRITERION TGX	64414906	LCLAB28	10	29/Jun/2021
33	LC	5678124	ANY KD CRITERION TGX	64429406	LCLAB28	47	05/Oct/2021
34	LC	5678124	ANY KD CRITERION TGX	64422769	LCLAB28	53	05/Oct/2021
35	LC	ANI0001	16206F BALB/cOlaHsd	170322AWO	ELABRT	2	08/Apr/2021
36	LC	ANI0001	16206F BALB/cOlaHsd	170875NCO	ELABRT	2	12/Jul/2021
37	LC	ANI0001	16206F BALB/cOlaHsd	090921	ELABRT	2	16/Sep/2021
38	LC	ANI0001	16206F BALB/cOlaHsd	210921	ELABRT	2	01/Oct/2021
LC_Stock

Cell Formulas
Range	Formula
K2:K5	K2	=IFERROR(INDEX(C$2:C$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/($B$2:$B$100=$J$2),ROWS(K$2:K2))),"")
L2:O5	L2	=IFERROR(INDEX(D$2:D$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/($B$2:$B$100=$J$2),ROWS(L$2:L5))),"")
K6:O12	K6	=IFERROR(INDEX(C$2:C$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/($B$2:$B$100=$J$2),ROWS(K$2:K16))),"")

 

[afc171]

ok figured it out after looking at the code lol
Thanks Fluff for your help.

 

[afc171]

If I wanted to add more products in J range would that be possible?

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	warehouse	product	description	lot_number	bin_number	quantity	date_received			product		description	lot_number	bin_number	quantity	date_received
2	LC	100 VIAL BOX	100 VIAL BOX	280319		5	28/03/2019			1351118	1351118	VIVAFIX 649/660	2680021	LCLAB201	1	44463
3	LC	100 VIAL BOX	100 VIAL BOX	290419		8	29/04/2019			1610782	1351118	VIVAFIX 649/660	2610052	LCLAB201	1	44488
4	LC	12004271	ZE5 Additive	1220L420	LC16	1	25/08/2021			ANI0001	1610782	TBS 1% CASEIN BLOCKI	64406796	LCLAB28	2	44379
5	LC	12004271	ZE5 Additive	0521L510	LC16	2	09/09/2021				1610782	TBS 1% CASEIN BLOCKI	64422511	LCLAB28	1	44449
6	LC	12004272	Cytometer Cleaner	64405351	LC16	2	21/09/2021				ANI0001	16206F BALB/cOlaHsd	170322AWO	ELABRT	2	44294
7	LC	12004403	ZE Series QC Bead	BR010517C	LCPRO401	1	02/09/2020				ANI0001	16206F BALB/cOlaHsd	170875NCO	ELABRT	2	44389
8	LC	12004403	ZE Series QC Bead	01M-122120	LCPRO401	2	05/10/2021				ANI0001	16206F BALB/cOlaHsd	90921	ELABRT	2	44455
9	LC	1351114	VIVAFIX 398/550	2361222	LCLAB201	2	24/09/2021				ANI0001	16206F BALB/cOlaHsd	210921	ELABRT	2	44470
10	LC	1351118	VIVAFIX 649/660	2680021	LCLAB201	1	24/09/2021
11	LC	1351118	VIVAFIX 649/660	2610052	LCLAB201	1	19/10/2021
12	LC	1450016	COUNTING SLIDES	210305	ELABRT	5	07/10/2021
13	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	1	03/08/2021
14	LC	1610393	PRECISION ALL BLUE	64419800	LCLAB201	3	14/09/2021
15	LC	1610396	UNSTAINED PROTEIN	64359194	LCLAB201	1	10/03/2021
16	LC	1610610	DITHIOTHREITOL (DTT)	64367890	LCLAB28	1	16/06/2021
17	LC	1610610	DITHIOTHREITOL (DTT)		LCLAB28	2	09/09/2021
18	LC	1610737	LAEMMLI SAMPLE BUFF	64394236	LC16	2	12/04/2021
19	LC	1610747	LAEMMLI SAMPLE BUFF	64388927	LC16	2	29/03/2021
20	LC	1610772	TGS (10x)	64394630	LC17	1	17/03/2021
21	LC	1610782	TBS 1% CASEIN BLOCKI	64406796	LCLAB28	2	02/07/2021
22	LC	1610782	TBS 1% CASEIN BLOCKI	64422511	LCLAB28	1	10/09/2021
23	LC	1704157	PVDF TRANSBLOT	64416630	LCLAB28	3	14/09/2021
24	LC	1704159	MIDI NITROCELLULOSE	64376912	LCLAB28	2	10/03/2021
25	LC	1705061	CLARITY WESTERN ECL	102031588	LC16	3	10/03/2021
26	LC	1705061	CLARITY WESTERN ECL	102031562	LC16	1	24/03/2021
27	LC	20X30	20X30 BAGS 250g		LC	3	17/08/2017
28	LC	30389292	USE DIS0008	211,922,327	LC7	1	02/07/2021
29	LC	30389292	USE DIS0008	212,631,543	LC7	1	27/07/2021
30	LC	5678084	CRITERION 4-15% TGX	64424017	LCLAB28	19	25/08/2021
31	LC	5678084	CRITERION 4-15% TGX	64427926	LCLAB28	21	05/10/2021
32	LC	5678124	ANY KD CRITERION TGX	64414906	LCLAB28	10	29/06/2021
33	LC	5678124	ANY KD CRITERION TGX	64429406	LCLAB28	47	05/10/2021
34	LC	5678124	ANY KD CRITERION TGX	64422769	LCLAB28	53	05/10/2021
35	LC	ANI0001	16206F BALB/cOlaHsd	170322AWO	ELABRT	2	08/04/2021
36	LC	ANI0001	16206F BALB/cOlaHsd	170875NCO	ELABRT	2	12/07/2021
37	LC	ANI0001	16206F BALB/cOlaHsd	90921	ELABRT	2	16/09/2021
38	LC	ANI0001	16206F BALB/cOlaHsd	210921	ELABRT	2	01/10/2021
39	LC	ANI0002	16206M BALB/C6-8	171063NCO	ELABRT	2	12/08/2021
40	LC	ANI0004	1702M LEW/SsNHsd RAT	171063NCO	ELABRT	2	12/08/2021
41	LC	ANI0004	1702M LEW/SsNHsd RAT	290921	ELABRT	4	29/09/2021
42	LC	ANI0006	1704M 4-6 WK RATS	170322AWO	ELABRT	2	08/04/2021
43	LC	ANI0006	1704M 4-6 WK RATS	170875NCO	ELABRT	10	12/07/2021
44	LC	ANI0006	1704M 4-6 WK RATS	171063NCO	ELABRT	6	12/08/2021
45	LC	ANI0015	5717F C57BL/6/cOla	151021	ELABRT	10	15/10/2021
46	LC	ANI0016	5717M C57BL/6/Jola	170770NCO	ELABRT	5	24/06/2021
47	LC	ANI0016	5717M C57BL/6/Jola	171063NCO	ELABRT	1	12/08/2021
48	LC	ANI0017	LARGE CONTAINER	170770NCO	ELABRT	1	24/06/2021
49	LC	ANI0017	LARGE CONTAINER	170875NCO	ELABRT	1	12/07/2021
50	LC	ANI0017	LARGE CONTAINER	151021	ELABRT	1	15/10/2021
51	LC	ANI0018	SMALL CONTAINER	170322AWO	ELABRT	3	08/04/2021
52	LC	ANI0018	SMALL CONTAINER	170875NCO	ELABRT	2	12/07/2021
53	LC	ANI0018	SMALL CONTAINER	171063NCO	ELABRT	4	12/08/2021
54	LC	ANI0018	SMALL CONTAINER	90921	ELABRT	1	16/09/2021
55	LC	ANI0018	SMALL CONTAINER	290921	ELABRT	1	29/09/2021
56	LC	ANI0018	SMALL CONTAINER	210921	ELABRT	1	01/10/2021
57	LC	BLO0001	BEAGLE BLOOD IN EDTA	A2081421	LC	1	05/08/2021
58	LC	CHE0006	MYCOALERT ASSAY	1022992	LCLAB28	4	09/09/2021
59	LC	CHE0007	MYCOALERT + DET KIT	72089342	LCLAB28	1	26/04/2021
60	LC	CHE0007	MYCOALERT + DET KIT	81021	LCLAB28	4	08/10/2021
61	LC	CHE0009	CONCANAVALIN A	SLCC7678	LCLAB201	1	27/04/2021
62	LC	CHE0011	A7906-500G BSA	SLCK4288	LCLAB28	3	21/07/2021
63	LC	CHE0012	IONOMYCIN	109M4048V	LCLAB28	1	27/04/2021
64	LC	CHE0013	PMA	SLBX8889	LCLAB201	1	27/04/2021
65	LC	CHE0014	SHEATH FLUID	2106809820	LC25	1	28/04/2021
66	LC	CHE0014	SHEATH FLUID	2119609817	LC25	3	27/08/2021
67	LC	CHE0015	PHA-P	SLCC9870	LCLAB28	1	27/04/2021
68	LC	CHE0016	FACS CLEAN SOLUTION	2101909812	LC10	1	28/04/2021
69	LC	CHE0016	FACS CLEAN SOLUTION	2118709823	LC10	3	13/09/2021
70	LC	CHE0020	HUMAN SERUM	SLBX6359	LCLAB201	1	27/04/2021
71	LC	CHE0020	HUMAN SERUM	SLCF0691	LCLAB201	2	09/09/2021
72	LC	CHE0021	BOVINE SERUM ADULT	20G024	LCLAB201	1	07/05/2021
73	LC	CHE0022	HARD SET DAPI	ZH0720	ELAB04	1	15/09/2021
74	LC	CHE0023	ACUITY ADVANCED	B339419	LCLAB28	2	24/05/2021
75	LC	CHE0024	CHROMOGEN CONCENTRAT	B333546	LCLAB28	1	25/10/2021
76	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	1	26/04/2021
77	LC	CHE0025	DAB SUBSTRATE BUFFER	B321516	LCLAB28	2	25/10/2021
78	LC	CHE0028	TC GRADE DMSO	RNBK1495	LC22	1	06/05/2021
79	LC	CHE0028	TC GRADE DMSO	RNBK3905	LC22	2	21/09/2021
80	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	3	05/05/2021
81	LC	CHE0040	MYCOPLASMA OFF LIQUI	150M21C1	LC14COSH	8	20/10/2021
82
Main

Cell Formulas
Range	Formula
K2:P10	K2	=IFERROR(INDEX(B$2:B$100,AGGREGATE(15,6,(ROW($B$2:$B$100)-ROW($B$2)+1)/(($B$2:$B$100=$J$2)+($B$2:$B$100=$J$3)+($B$2:$B$100=$J$4))/($B$2:$B$100<>""),ROWS(K$2:K2))),"")

 

[afc171]

Awesome, that is spot on. Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.