If, go to cell formula or VBA

[tpedry]

I have a spreadsheet that I would like one cell to reference another, if the referenced cell has the value of "SUB" then I would like the formula or code to jump to a particular cell on another sheet.

Here is the formula, I have so far. It is not throwing any errors, it just doesn't jump to cell 'Labor Codes'!F43 . The rest of the formula is for a Vlookup that works just fine if AC21<>"SUB"

=IF(AC21="",0,IF(AC21="SUB",'Labor Codes'!F43,VLOOKUP(AC21,SubLaborCodes,2,0)))

[tpedry]

Here is the worksheet in question.

Source and referenced cells are on 'Blue Mantle Est Worksheet' and destination cell is on 'Labor Codes' sheet.