Using INDEX and MATCH in Microsoft Excel or Google Spreadsheet / Lim Teck Heng

Lim, Teck Heng (2022) Using INDEX and MATCH in Microsoft Excel or Google Spreadsheet / Lim Teck Heng. Bulletin. Academy of Language Studies.

Abstract

In the previous article, we have looked at VLOOKUP and how to use it to find and display the data we want. The main problem with VLOOKUP is that the lookup_value must always be in the left-most column of the lookup table. This, however, is not always possible (compare Figure 1 & 2).
Problem with VLOOKUP
In Figure 1, the name column is the left-most column. When we enter the formula =VLOOKUP($H$5, $A$2:$E$11, 5, FALSE) in cell H6, we get 19 i.e., the correct result.

Metadata

Item Type: Monograph (Bulletin)
Creators:
Creators
Email / ID Num.
Lim, Teck Heng
limth309@ppinang.uitm.edu.my
Contributors:
Contribution
Name
Email / ID Num.
Advisor
Aboo Bakar, Rofiza
UNSPECIFIED
Subjects: L Education > LG Individual institutions
L Education > LG Individual institutions > Asia > Malaysia
L Education > LG Individual institutions > Asia > Malaysia > Universiti Teknologi MARA > Pulau Pinang
L Education > LG Individual institutions > Asia > Malaysia > Universiti Teknologi MARA
L Education > LG Individual institutions > Asia
Divisions: Universiti Teknologi MARA, Pulau Pinang > Permatang Pauh Campus > Academy of Language Studies
Journal or Publication Title: e-Lingua
ISSN: 2600-7134
Keywords: e-Lingua, Academy of Language Studies, UiTM
Date: 2022
URI: https://ir.uitm.edu.my/id/eprint/68399
Edit Item
Edit Item

Download

[thumbnail of 68399.pdf] Text
68399.pdf

Download (514kB)

ID Number

68399

Indexing

Statistic

Statistic details