Vlookup not working properly?!

[afc171]

Hi all,

I these two sheets to lookup a product and to show if it is in the list or not, for some reason for example PKG0017 is in stock but shows as No..

4Despatch Consumables V1 (1).xlsm
	A	B	C	D	E
2	product	long_description	stock unit	Book Out QTY	In Stock?
3	GEN0023	Azowipes	EACH	1 EACH	Yes
4	GEN0030	Absorbent Spill Mat	EACH	1 EACH	No
5	PKG0001	BUF BOX 120 X 79 X 60MM	EACH	1 EACH	Yes
6	PKG0002	CARDICE 11.5KG BAG 10MM PELLETS	EACH	1 EACH	Yes
7	PKG0003	BUF BOX SLEEVES LIT.BUF	EACH	1 EACH	Yes
8	PKG0004	BOVINE KIT SLEEVE LIT.KIT BOV	EACH	1 EACH	Yes
9	PKG0005	ICT KIT SLEEVE LIT.KIT PACK	EACH	1 EACH	Yes
10	PKG0006	MMT/RMT KIT SLEEVE LIT.MMT	EACH	1 EACH	Yes
11	PKG0007	MED DRY ICE BOX 283X283X259MM	EACH	1 EACH	Yes
12	PKG0008	SINGLE WALL BROWN BOX 305X228X130MM L25	EACH	1 EACH	Yes
13	PKG0009	DOUBLE WALL BROWN BOX 305X305X305MM L49	EACH	1 EACH	Yes
14	PKG0010	A4 PLAIN DOC ENCLOSED WALLETS 1000/BOX	EACH	1 (BOX 1000)	Yes
15	PKG0011	A7 PLAIN DOC ENCLOSED WALLETS 1000/BOX	EACH	1 (BOX 1000)	Yes
16	PKG0012	SINGLE WALL BROWN BOX - DELETED	EACH	1 EACH	No
17	PKG0013	BROWN TAPE LOW NOISE 48MMX66M 36/BOX	EACH	1 (PACK 6)	Yes
18	PKG0014	BUBBLE BAG 130MMX185MM 500/BOX	EACH	1 (BOX 500)	Yes
19	PKG0015	SMALL BUBBLE WRAP - 3X500MMX200M	EACH	1 ROLL	Yes
20	PKG0016	CLEAR TAPE LOW NOISE 48MMX66M 36/BOX	EACH	1 (PACK 6)	Yes
21	PKG0017	WHITE M/LITE ENV MLPF/3 220X330MM 50/BOX	EACH	1 (BOX 50)	No
22	PKG0018	WHITE M/LITE ENV MLPH/5 270X360MM 50/BOX	EACH	1 (BOX 50)	Yes
23	PKG0019	150W/TE DIECUT CARTON 513X365MM ICT	EACH	1 EACH	Yes
24	PKG0020	WHITE M/LITE ENV MLPK/7 350X470MM 50/BOX	EACH	50 (BOX)	Yes
ProductList

Cell Formulas
Range	Formula
E3:E24	E3	=IF(ISNA(VLOOKUP(A3,'Despatch-LC-Stock'!B:H,1,FALSE)),"No","Yes")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3:E55	Cell Value	contains "No"	text	NO

4Despatch Consumables V1 (1).xlsm
	B	C	D	E	F	G	H
2	product	long_description	lot_number	bin_number	quantity	inspection_date	expiry_date
3	GEN0023	Azowipes	15278	LC14COSH	8	20/Jun/2022	31/May/2024
4	GEN0023	Azowipes	15852	LC14COSH	19	29/Jul/2022	30/Jun/2024
5	GEN0023	Azowipes	15959	LC14COSH	20	26/Aug/2022	30/Jun/2024
6	PKG0001	BUF BOX 120 X 79 X 60MM	300421	LC/P8	135	30/Apr/2021
7	PKG0001	BUF BOX 120 X 79 X 60MM	260422	LC/P8	1821	26/Apr/2022
8	PKG0002	CARDICE 11.5KG BAG 10MM PELLETS	051022	KD80	3	05/Oct/2022
9	PKG0003	BUF BOX SLEEVES LIT.BUF	170566KSC	LC/P8	294	27/May/2021
10	PKG0004	BOVINE KIT SLEEVE LIT.KIT BOV	090719	LC/P8	68	09/Jul/2019
11	PKG0004	BOVINE KIT SLEEVE LIT.KIT BOV	031019	LC/P8	154	03/Oct/2019
12	PKG0005	ICT KIT SLEEVE LIT.KIT PACK	031019	LC/P8	312	03/Oct/2019
13	PKG0006	MMT/RMT KIT SLEEVE LIT.MMT	169162LC	LC/P8	949	30/Sep/2020
14	PKG0007	MED DRY ICE BOX 283X283X259MM	041022	LC/P8	60	04/Oct/2022
15	PKG0008	SINGLE WALL BROWN BOX 305X228X130MM L25	170367KSC	LC/P8	14	22/Apr/2021
16	PKG0008	SINGLE WALL BROWN BOX 305X228X130MM L25	211021	LC/P8	100	21/Oct/2021
17	PKG0009	DOUBLE WALL BROWN BOX 305X305X305MM L49	167212KSC	LC/P8	71	01/Oct/2019
18	PKG0010	A4 PLAIN DOC ENCLOSED WALLETS 1000/BOX	150720	LC/P8	3000	15/Jul/2020
19	PKG0011	A7 PLAIN DOC ENCLOSED WALLETS 1000/BOX	091019	LC/P8	5	09/Oct/2019
20	PKG0013	BROWN TAPE LOW NOISE 48MMX66M 36/BOX	161121	LC/P8	180	16/Nov/2021
21	PKG0014	BUBBLE BAG 130MMX185MM 500/BOX	081221	LC/P8	360	08/Dec/2021
22	PKG0015	SMALL BUBBLE WRAP - 3X500MMX200M	210422	LC/P8	2	21/Apr/2022
23	PKG0016	CLEAR TAPE LOW NOISE 48MMX66M 36/BOX	031019	LC/P8	102	03/Oct/2019
24	PKG0017	WHITE M/LITE ENV MLPF/3 220X330MM 50/BOX	170274KSC	LC/P8	800	26/Mar/2021
25	PKG0018	WHITE M/LITE ENV MLPH/5 270X360MM 50/BOX	100621	LC/P8	300	10/Jun/2021
26	PKG0019	150W/TE DIECUT CARTON 513X365MM ICT	170565KSC	LC/P8	2389	21/Jul/2021
27	PKG0020	WHITE M/LITE ENV MLPK/7 350X470MM 50/BOX	031019	LC/P8	150	03/Oct/2019
Despatch-LC-Stock

 

[Fluff]

In A21 it looks as though there is a space after PKG0017 which is why it says No.

 

[afc171]

Fluff to the rescue, I even ran Text to columns but used space this time and it sorted it. Thanks mate.

 

[Fluff]

Glad to help & thanks for the feedback.