Forum Discussion
Solved
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...
=VLOOKUP(B3,Sheet2!$B$3:$C$8,2,FALSE)You can try VLOOKUP. An alternative could be INDEX and MATCH.
=VLOOKUP(B3,Sheet2!$B$3:$C$8,2,FALSE)You can try VLOOKUP. An alternative could be INDEX and MATCH.
Brilliant - Thank you 🙂