VLOOKUP exact match

1 / 6

We want the price of Office Chair. The answer goes in F2.

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCDEFG
1ProductCategoryPriceProductPrice
2Monitor StandAccessories40.49Office Chair
3HeadsetElectronics73.25
4Office ChairFurniture132.49
5BookshelfFurniture65.5
6USB-C HubElectronics40.25
7Notebook A5Stationery3.99
8Filing CabinetFurniture170.5
9Desk OrganiserAccessories20.49
10WhiteboardOffice69.5
11Wireless MouseElectronics33
12
13
14
15
find this
answer here
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

How VLOOKUP works

  • What does VLOOKUP do?

    VLOOKUP finds a value in the first column of a table, then returns a value from another column in the same row.

    =VLOOKUP(lookup_value, table_array, col_index_num, FALSE)

  • What are its four parts?

    • lookup_value: what you are looking for, e.g. a product name.
    • table_array: the whole table, starting with the column you search.
    • col_index_num: which column of the table to return. The first column is 1.
    • FALSE: exact match.

  • Why add FALSE?

    Leave it out and VLOOKUP guesses, which gives wrong answers on unsorted data.

Know someone fighting with a spreadsheet? Send them this page.