In Google Sheets I have a search box that brings up the information for a person when you type in their id. It works perfectly up until ID 512, which is row 374. The formula I use:
=IFERROR(VLOOKUP(C3,'Main Database'!B21:S590,3,True),"")
Google-sheets – VLOOKUP stops working after 500 rows
google sheetsvlookup
Related Topic
- Google-sheets – Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE – use ARRAY or VLOOKUP
- Google-sheets – Vlookup using Regex Extract
- Google Sheets – How to Emulate Vlookup in Google Script
- Google-sheets – Find value in 2 different sheets
- Google-sheets – Trying to search(from sheet1 ) for a value on in any row of sheet2
- Google-sheets – Why does VLOOKUP find a match in a sequence of dates when there is none
Best Answer
Ensure that the material in Main Database is sorted by ascending contents of the first column in it.
(It's safest to select the whole range manually and then sort it.)