Forum Discussion
Lennox2525
May 22, 2023Copper Contributor
How to calculate a result based on a data table
Hi,
I have added a sample data file. On Sheet 2 is the 'master' data Clothing and Units.
On sheet 1 I have produced what I need the final result to be.
Basically Clothing will be a drop down. If Jeans are selected, Units will auto fill with '1'. When the sales amount is manually entered the Total Units will then be calculated.
Can anyone help me with this solution please?
=VLOOKUP(B3,Sheet2!$B$3:$C$8,2,FALSE)
You can try VLOOKUP. An alternative could be INDEX and MATCH.
2 Replies
Sort By
- OliverScheurichGold Contributor
=VLOOKUP(B3,Sheet2!$B$3:$C$8,2,FALSE)
You can try VLOOKUP. An alternative could be INDEX and MATCH.
- Lennox2525Copper ContributorBrilliant - Thank you 🙂