VLOOKUP pulling incorrect and nonexistent information.

I working on making a spreadsheet template. What I have is a list of numbers. I need information about these specific numbers from a much larger list of numbers. I use VLOOKUP to find the number in the large list has give back the information I want from the list into the cell I need it in. But VLOOKUP is not working. One of the numbers that I need does not exist on the large list, yet VLOOKUP still pulls information for the number. I ran a search of the big list to check and make sure the number isn't there. The search finds nothing. Where is VLOOKUP getting its information from then? And how do I fix it? A copy of my VLOOKUP formula is below.


=VLOOKUP(A2,Sheet2!A585:F60584,3)

Well...throughout my work with Excel on vlookup. IF vlookup gives you a value (not #N/A), that means, the value return is indeed there.

From your formula, the value in cell A2 was found on column C from row 585 to 60584.

Also, please note that if you were to drag the formula, example A3, instead of row 585 to 60584, it'll now be from row 586 to 60585.

Adding the False argument worked. Thanks guys.