Excel: Combining HLOOKUP and VLOOKUP
This video tutorial combines HLOOKUP and VLOOKUP which is great if you have a matrix and want to be able to select a particular column or row. Here I use a table with delivery charges to various cities so you can select where it is going from and where it is going to. Gary Schwartz from http://www.jargonfreehelp.com shows us how.
You may need to familiarise yourself with VLOOKUP and HLOOKUP first. Here are tutorials to help with that:
VLOOKLUP: • Excel: VLOOKUP Function Tutorial
HLOOKUP: • Excel: How to Use the HLOOKUP Function
This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0
For more tutorials see my website http://www.jargonfreehelp.com
I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.
Watch video Excel: Combining HLOOKUP and VLOOKUP online without registration, duration hours minute second in high quality. This video was added by user jargonfreehelp 26 December 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 110,704 once and liked it 315 people.