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
![[thumbnail of 68399.pdf]](https://ir.uitm.edu.my/style/images/fileicons/text.png)
