• Create and Learn

VLOOKUP + Data Validation. 10 Steps. Create and Learn

A true story!

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":

https://www.amazon.com/dp/B01DVM69LC/ref=cm_sw_su_dp



If you liked the post, please share by clicking below.






Power BI Academy: HR Recruitment

Create a complete dashboard for Human Resources. Bonus: 10 Templates

Excel Easy: Dashboards

Made Simple

Few pages, quick steps, and professional dashboards

Power BI – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Power BI 2019.jpg

Tableau – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Tableau ebook 2019.jpg

Power BI, Excel and Tableau – BI Clinic

Learn how to create Dashboard using Power BI, Excel and Tableau.

BI Clinic Complete Single cover.jpg

Excel – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Excel BI ebook 2019.jpg

For any inquiries, please contact us:

© Brain Words