 How to learn VLOOKUP in under one minute. Enter equals VLOOKUP. Select the value that you wish to search for comma. Select the entire range containing a column with the value you wish to search for and the value you wish to return comma. Enter as a number the column that you wish to return a value from. I wish to return a value from the age column and this is the second column in my range so I enter number two comma. Define how you wish to search for your search value. You can either use approximate match or an exact match. I'm going to be using an exact match, close brackets, hit enter and now the formula returns our desired value. If I change my search name to Claire you can see the formula now updates and pulls back the applicable age for Claire. Be sure to like and subscribe for more videos.