=IF(F24="","",IF(G24="",SUM(H25:***here***),G24*IF (ISNA(VLOOKUP(F24,A:H,8,FALSE))=TRUE,VLOOKUP(F24,P RICING!A:C,3,FALSE),VLOOKUP(F24,A:H,8,FALSE))))

is there code that will identify the next cell in a column with a specific
value?

that being the case I could use "" as that value

any thoughts?