Combining VLOOKUP and HLOOKUP Functions

Gary Schwartz's Blog

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and the other with the value to retrieve with the HLOOKUP you could get it to get values from more than one column.

In the example in the video below you can see how I used this to determine delivery charges from one to city to another using a table of charges based on the cities. The HLOOKUP determined which column the delivery was coming from and the VLOOKUP uses the row where it is going to. The HLOOKUP has the column number which the VLOOKUP uses for determining the column index number.

If you need to know about the VLOOKUP and HLOOKUP function you can see these on my website

View original post 9 more words