Combining an If Or statement with a Vlookup

[RLB1127]

I have (2) sheets,
Sheet 1 contains all of my data with Col. B listing types of skincare products.

I have (2) conditions I'm searching for in Col B:

If Col B contains (or equals) "Lotion" I need to look at the brands in Col C, then perform a VLOOKUP which tell assigns a type to the lotion. If the brand isn't listed the result should be "AO HBL".

If Col B contains (or equals) "Cleanser" then look in Column D and give me the Type.

If something else is in Col B, then ignore.

This is the formula I've tried:
=IF(Or($B3="LOTION",VLOOKUP($C3,'SHEET2'!$B$3:$D$19,2,0),"AO HBL"),IF($B3="CLEANSER",D2),<>))

Any assistance appreciated.

 

[FDibbins]

Mybe this...
=IF($B3="LOTION",if(iserror(VLOOKUP($C3,'SHEET2'!$B$3:$D$19,2,0)),"AO HBL"),IF($B3="CLEANSER",D2),<>))