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...
Bookmarks