Nested If/Or statement with a VLookup based off a list using first 2 characters

[Deelof]

I want to extend my current formula to add a condition using a list based off the first 2 characters of the variant SKU.
Any suggestions?

Status	Published	Variant SKU	RESULT	CURRENT FORMULA	ADDITION I WANT TO MAKE AS NESTED
Archived	FALSE​	BK00001-1	NOT TO GO ON	=IF(OR(F6="ACTIVE",G6="TRUE"),"ON","NOT ON")	LEFT 2 CHARACTERS AGAINST THE LOOKUP LIST MATCH AND RETURN "NOT TO GO ON"
Active	TRUE​	CH00001-1	ON
Draft	FALSE​	BT00001-1	NOT ON
Active	TRUE​	MW00002-1	NOT TO GO ON
Archived	FALSE​	AR00001-1	NOT ON

VLOOKUP LIST
BK	NOT TO GO ON
BU	NOT TO GO ON
CK	NOT TO GO ON
DW	NOT TO GO ON
FF	NOT TO GO ON
FP	NOT TO GO ON
GM	NOT TO GO ON
HD	NOT TO GO ON
IB	NOT TO GO ON
IR	NOT TO GO ON
KT	NOT TO GO ON
MW	NOT TO GO ON
SF	NOT TO GO ON
STA	NOT TO GO ON
TS	NOT TO GO ON
TV	NOT TO GO ON
VC	NOT TO GO ON
WM	NOT TO GO ON

 

[SanjayGMusafir]

That is what the OP is asking for help with.

@Fluff Thanks for getting in. That shall help me.

If you look at the threads above #4 - I have already given the formula to work on. I have urged him to use that and come with the errors (speaking technically)

Since you have taken over, I shall take exit from this thread. And I know you would be able to help in the best possible way.

Regards