Excel: Combining VLOOKUP and HLOOKUP Functions

Hopefully you know how to use the VLOOKUP function and the HLOOKUP function, if not then click here to see the tutorial on the VLOOKUP function and click here for the HLOOKUP function.

Using both allows you to find the values in a matrix rather than being able to retrieve the values in just one column. In the example in this video tutorial you will see how I used this to determing delivery costs from one city to another.

You will find there are many uses for this.

One thought on “Excel: Combining VLOOKUP and HLOOKUP Functions

Comments are closed.