Vlookup And Hlookup Examples. Data table structure matters a lot. The functions vlookup and hlookup among excel users are very popular.
In the example below we are using the member id field in the workshop registrations dataset to find the same member id in the members dataset to return the first name linked to the id. In this example you will see how to use two or more table arrays in the excel vlookup formula. Below is an example of the less commonly used hlookup function.
Data table structure matters a lot.
For that reason understanding vlookup hlookup is still a worthwhile exercise. The returned value by hlookup is 5 because hlookup searches for 2016 in the range b3 e4 in row 2. The first function is used for vertical analysis comparison. In this formula the horizontal value 2016 is looked up with the hlookup section of the formula.
