VLOOKUP & SUMIF

System

This discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum).

User: Anthony12345678
Post:
Having a similar issue. The Only difference is that my cells have the vslookup formula "=VLOOKUP(C3,Data!$D$1:$F$25, 2, FALSE)" in side them. When employees fill out the google forms, some of the data will auto populate the spread sheet. My goal is to have it auto calculate the cost. For example, if a form is filled out requesting a door, when item populates the sheet vslookup will use the chart to display the cost. If i use the sum function on cells without a dollar amount, and just the formula, I get #N/A did not find value. Is there a way to make it over look the formula until a value is input into the cell by vslookup

Anthony12345678

David,

Having a similar issue. The Only difference is that my cells have the vslookup formula "=VLOOKUP(C3,Data!$D$1:$F$25, 2, FALSE)" in side them. When e

mployees fill out the google forms, some of the data will auto populate the spread sheet. My goal is to have it auto calculate the cost. For example, if a form is filled out requesting a door, when item populates the sheet vslookup will use the chart to display the cost. If i use the sum function on cells without a dollar amount, and just the formula, I get #N/A did not find value. Is there a way to make it over look the formula until a value is input into the cell by vslookup