Vhlookup - Combination Of Vlookup And Hlookup

  • The code below is a combination of HLOOKUP and VLOOKUP. Instead of entering the number of the row/column in the range you can enter a value from the upper row or left column.

    When one of the values you search on is not found a zero is returned.

    Copy this code to a VBA module to create this user defined function.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!