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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 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!