﻿ Excel functions VLOOKUP and HLOOKUP - formula examples | AnswerTabs

# Excel functions VLOOKUP and HLOOKUP - formula examples

Would you please provide working examples of VLOOKUP and HLOOKUP functions ? The formulas I have created are not working for some reason.
 12 Dec 2020 at 02:55 PM
Hi,

VLOOKUP function in the following example is used to get the unit price from the second table, that is created on another sheet.

The first table:

The second table on another sheet:

To get unit price from the second table for C2, the formula should look like:

=VLOOKUP(A2;Sheet2!\$A\$2:\$D\$4;4;FALSE)

A2 - lookup value
Sheet2!\$A\$2:\$D\$4 - table array, which describes the fixed location of the second table
4 - the column index number, which describes the column where the value is located
FALSE - used to apply the exact match

When you are using the tables as objects, the formula in C2 can also look like:

=VLOOKUP([@Item],Table2,4,FALSE)

HLOOKUP function in the following example is used to get the percentage rate from the first table, to calculate the selling price:

To get percentage rate from the first table for D7, the formula should look like:

=HLOOKUP(B7;\$B\$1:\$E\$2;2;FALSE)

B7 - lookup value
\$B\$1:\$E\$2 - table array, which describes the fixed location of the first table
2 - the row index number, which describes the row where the value is located
FALSE - used to apply the exact match
 13 Dec 2020 at 01:57 PM
Related questions

## How to calculate percentage changes / growth in Excel ?

Trending questions
Remove or hide bottom navigation bar with buttons on Android
How to calculate inverse currency exchange rate ?
HTML list <ul> not showing items <li> on a new line
Is better browser Internet explorer or Microsoft Edge ?
Is England's national dish / meal Fish & chips or Roast beef ?
Is it possible to add / increase RAM memory in Laptop ?
Incorrect integer value '' for column 'user_id' at row 1 - error