The Student Room Group

gcse ict edexcel music festival cab

Someone please help me!
How and when do i use data validation and VLOOKUP in my spreadsheet model?
I'm not too sure about uses of VLOOKUP but data validation can be used to make sure when testing the model the values aren't too high and too low. You can do this by inserting a minimum and maximum value for some of the numerical data and you can let it show a specific error message if the value is wrong.

Posted from TSR Mobile

Quick Reply

Latest