My VLOOKUP seems to be pulling the wrong information. =VLOOKUP(AE1,'Study Database'!B9:AN6000,9)
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...