# VLOOKUP ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] #### Sub-context: [[Spreadsheet]] >[! Definition] >A function that searches for a certain value in a column to return a related piece of information ## Examples ```Spreadsheet =VLOOKUP(`search_key,` `range, index,` [`is_sorted`]) ``` `search_key` is the value you are looking for `range` is the upper and lower values bounding the search column `index` the index of the column with the return value (must be +) the search column is column 1 ## Related XLOOKUP; new function that works in any direction ## Resources [EXCEL VLOOKUP Docs](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1) [Google sheets docs](https://support.google.com/docs/answer/3093318?hl=en) [How to use VLOOKUP in Excel](https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1) [VLOOKUP in Excel tutorial](https://www.youtube.com/watch?v=d3BYVQ6xIE4) [23 things to know about VLOOKUP in Excel](https://exceljet.net/things-you-should-know-about-vlookup) [VLOOKUP in Excel vs Google Sheets](https://infoinspired.com/sheets-vs-excel-formula/vlookup-formula-in-excel-and-google-sheets/) ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) A function that searches for a certain value in a column to return a related piece of information @@@ [[VLOOKUP|=VLOOKUP()]]