VLOOKUP & SUMIF

System
System Employee Admin
edited 01/05/20 in Formulas and Functions
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

Comments

  • 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!