Odd VLOOKUP Error
 

Thanks Keith!

I'd tried using FALSE ane it kept erroring out. using 0 at the end worked
though. Thanks again!

"ker_01" wrote:

Vlookup requires data to be sorted- so if your values are not in order, it
will return the first one that 'exceeds' your search value.

To only return exact values, change your formula to:
=IF(A9="","",VLOOKUP(A9,AttendanceTable,4,False))
or
=IF(A9="","",VLOOKUP(A9,AttendanceTable,4,0))

Which will force it to only return a value when an exact match for A9 is
located.

Note that if the value in A9 shows up multiple times in your lookup table,
it will only return the first match it finds.

HTH,
Keith

"TheDrescher" wrote:

Hey all, I'm running into an issue with a workbook that uses VLOOKUP to
display data on a front sheet using arrays found in other sheets based on a
selection made in Cell A9. The code I use is:
=IF(A9="","",VLOOKUP(A9,AttendanceTable,4))
The problem I am experiencing is random rows are not pulling the correct
data. This does not happen in every row, but a seemingly random selection of
them. Instead of pulling the data from the row with the correct A9 data in
them, it pulls from the row above. Is there something I'm doing wrong here?
Thanks!