Using VLOOKUP in Microsoft Excel or Google Spreadsheet / Lim Teck Heng
Ctrl+F is a keyboard shortcut that many of us are familiar with. We usually use it to find words or phrases quickly and efficiently when reading or browsing through an article on a website. We can also use it in word processing programs, spreadsheets, or even PDFs. Though Ctrl+F allows us to find sp...
Saved in:
| Main Author: | |
|---|---|
| Format: | Monograph |
| Language: | en |
| Published: |
Academy of Language Studies
2022
|
| Subjects: | |
| Online Access: | https://ir.uitm.edu.my/id/eprint/68397/1/68397.pdf https://ir.uitm.edu.my/id/eprint/68397/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Summary: | Ctrl+F is a keyboard shortcut that many of us are familiar with. We usually use it to find words or phrases quickly and efficiently when reading or browsing through an article on a website. We can also use it in word processing programs, spreadsheets, or even PDFs. Though Ctrl+F allows us to find specific data in Microsoft Excel and Google Spreadsheets, its usefulness stops there as we could not manipulate the data any further. In this short article, we will look at how to use VLOOKUP to find and display a particular data when using spreadsheets programs such as Microsoft Excel or Google Spreadsheet.
Let’s start by looking at the syntax Syntax: =VLOOKUP(lookup_value, table_array, col-index-num, rangejookup) |
|---|