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

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 wi...

Full description

Bibliographic Details

Main Author:	Lim, Teck Heng
Format:	Monograph
Language:	en
Published:	Academy of Language Studies 2022
Subjects:	LG Individual institutions Malaysia Pulau Pinang Universiti Teknologi MARA Asia
Online Access:	https://ir.uitm.edu.my/id/eprint/68399/1/68399.pdf https://ir.uitm.edu.my/id/eprint/68399/
Tags:	Add Tag No Tags, Be the first to tag this record!