VLOOKUP & SUMIF
System
Employee
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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 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!