VLOOKUP & SUMIF
System
Employee Admin
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
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
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!