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),"")
  • Note that you didn't make the ranges in the lookup table absolute so as you drag your formula down to C512, your lookup table is expected to start at B530. May not be the issue but thought to point it out. – BruceWayne Dec 6 '16 at 2:36

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.