W
woozlemonk
=IF(F24="","",IF(G24="",SUM(H25:***here***),G24*IF(ISNA(VLOOKUP(F24,A:H,8,FALSE))=TRUE,VLOOKUP(F24,PRICING!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?
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?