Can't get basic vlookup working for some reason on google sheets
Both lookup cells formatted at plain text, I don't think that's the issue. Searching for C186 returns 2 results proving they're correct. please see images.
this is filler text to get around the minimum words vs images requirement this is filler text to get around the minimum words vs images requirement this is filler text to get around the minimum words vs images requirement this is filler text to get around the minimum words vs images requirement this is filler text to get around the minimum words vs images requirement
Use 4th parameter as exact match. Also check manually that the value matches to each other by typing =C186=Sheet2!A80 it should return TRUE if matches.
I would recommend you to use XLOOKUP() instead of VLOOKUP() which is more versatile. Try-
=XLOOKUP(C186,Sheet2!A:A,Sheet2!B:B,"",0)
- How to count distinct column values in Google Sheets?
- GAS passing variables to time based triggers
- How do I get Google Script to read the display value of a sheet's cell? It keeps returning some random date instead
- Google Sheets - make a list of the names in column A where column E is greater than zero
- Allocating Specific Leaves and getting Calculation
- Randomize cells in Google Sheets
- Google sheet insertImage function stopped working for Google Apps Script: verify image error
- Is it possible to browse a spreadsheet when an importrange has been authorized?
- Disable Spreadsheet copy - Google Sheets
- Gsheet AppScript ShowModalDialogue no longer displaying HTML hyperlink
- IMPORT XML function - Stock Price - Google Sheets
- Combining array_constrain and arrayformula and getting results in multiple columns
- Combining scripts
- Google script to dynamically addressing a cell in google sheet
- Authorization is revoked every week. How to maintain persistent authorization?
- Best Practices for Multiple OnEdit Functions
- Sheets: My function uses commas to separate the INDEX MATCH results, but I don't want a comma for the blanks while still having them on matches
- Google Sheets Sumifs two arrays (Month and current year)
- Can't get basic vlookup working for some reason on google sheets
- Processing date formats in data from Forms
- ARRAYFORMULA with IMPORTRANGE
- MIN value excluding values lower then a value in another cell
- Set Data Validation Display style in Apps Script
- How to test type of range parameter in Google Spreadsheet script?
- Gsheet MAXIFS with FILTERed range
- How do I filter rows by whether or not certain columns have values?
- Standardize IDs from Multiple Columns into One Column
- Service Spreadsheets failed while accessing document with id - Intermittent
- Refresh data retrieved by a custom function in Google Sheet
- How to show "game over" when the Countdown is over in google sheets