I originally was using this function to declare a value until I came across records that had been updated with new values. How can I sum or average this to remove #value?

What am I doing wrong?

Original Function:
=IF(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'LWC Issues'!A:M,9,TRUE))*F19

Output: #value

Second Try:
=AVERAGE(IF(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'LWC Issues'!A:M,9,TRUE))*F19)

Output: #value

Third Try:
=AVERAGE(IF(Purchased!A6,'Cut Tube Issues'!A:K<>0,Purchased!A6,'Cut Tube Issues'!A:K(ISERROR(VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K,11,TRUE)),"",VLOOKUP(Purchased!A6,'Cut Tube Issues'!A:K<>0,Purchased!A6,'LWC Issues'!A:M(Purchased!A6,'LWC Issues'!A:M,9,TRUE))))

Output: Entered to many arguments or Your formula is missing a parenthesis...