Prev: Macro to delete rows
Next: not in array
From: TheDrescher on 27 May 2010 16:08
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!
> >
From: ker_01 on 27 May 2010 17:01
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!
>
 | 
Pages: 1
Prev: Macro to delete rows
Next: not in array