SOLVED

# How to calculate a result based on a data table

Copper 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?

2 Replies
best response confirmed by Lennox2525 (Copper Contributor)
Solution

# Re: How to calculate a result based on a data table

``=VLOOKUP(B3,Sheet2!\$B\$3:\$C\$8,2,FALSE)``

You can try VLOOKUP. An alternative could be INDEX and MATCH.

# Re: How to calculate a result based on a data table

Brilliant - Thank you 🙂
1 best response

Accepted Solutions
best response confirmed by Lennox2525 (Copper Contributor)
Solution

# Re: How to calculate a result based on a data table

``=VLOOKUP(B3,Sheet2!\$B\$3:\$C\$8,2,FALSE)``

You can try VLOOKUP. An alternative could be INDEX and MATCH.