Showing posts with label automation. Show all posts
Showing posts with label automation. Show all posts

Sunday, May 1, 2016

VLOOKUP + Data Validation. 10 Steps. Create and Learn


Use them together to create great dynamic information in your spreadsheet:

VLOOKUP: use one of the lookup and reference functions, when you need to find things in a table or a range by row. 
 Data Validation: Use to control the type of data or the values that users enter into a cell.