Formula ideas

Options
Stacy Meadows
Stacy Meadows ✭✭✭
edited 11/29/22 in Formulas and Functions

So here goes;

sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN}

Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match

I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!