﻿ 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

## IF multiple conditions - combined with AND and OR in Excel

Trending questions
How to calculate inverse currency exchange rate ?
How to add side by side rows in excel pivot table ?
Remove or hide bottom navigation bar with buttons on Android
How to change QWERTZ keyboard to QWERTY in Windows 10 ?
Invitation emails disappear after meeting is accepted in Outlook
How to see who is invited to a meeting - attendees in Outlook
How to calculate how many Man Days are 3 Man Hours ?