VLOOKUP pulls odd result

[jimmisavage]

Hi everyone,
My VLOOKUP seems to be pulling the wrong information. =VLOOKUP(AE1,'Study Database'!B9:AN6000,9)

Where;
AE1 = Dave
I was expecting the lookup to find Dave in the database which covers B9:AN6000 and pull the information on row 9 from the line which has Dave's information. Instead it's pulling information from 8 rows below Dave's row. What am I doing wrong here?

 

[jimmisavage]

Hi everyone,
My VLOOKUP seems to be pulling the wrong information. =VLOOKUP(AE1,'Study Database'!B9:AN6000,9)

Where;
AE1 = Dave
I was expecting the lookup to find Dave in the database which covers B9:AN6000 and pull the information on row 9 from the line which has Dave's information. Instead it's pulling information from 8 rows below Dave's row. What am I doing wrong here?

I seem to have fixed it by reducing the size of my table =VLOOKUP(AE1,'Study Database'!B9:AN1000,9)

 

[steve the fish]

If you arent sorting your column B then you arent using it correctly. You need to use an exact match:

=VLOOKUP(AE1,'Study Database'!B9:AN1000,9,0)