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.

1- Type the values and words in range A1:C10 as in the figure below.

2- Go to "Page Layout" tab, "Sheet Options" group and deselect "Gridlines View".

3 - Go to "Home" tab, "Borders" and "All borders to the ranges A1:C2 and A5:C10.

4- Select A2. Go to "Data" tab, "Data Tools" group and click on "Data Validation.

5- Select "List" and type =A6:A10  in "Source"

6- Click on the list and select "Maria".

7- Select B2 and type the formula =VLOOKUP(A2,A6:C10,B4,0)

8- Select B3 and type the formula =VLOOKUP(A$2,A6:C10,C4,0)

9- Check the explanation below to understand more about vlookup. Follow the colors.

10- Check the video of this file.

If you want to learn more about validation, vlookup, hlookup... Try my book "Dynamic Infographic":

If you like the post, please share by clicking on buttons below.

No comments:

Post a Comment