I am using a vlookup that is returning a wrong value. all of the data are
numeric, I have checked for spaces, text and used paste special for values.
the lookup table array is 2 colums x 9903 rows, sorted by the first column.
is there a restriction on the size of the lookup table array?
Thanks
Ken

"ken gault" wrote in message
...
I am using a vlookup that is returning a wrong value. all of the data are
numeric, I have checked for spaces, text and used paste special for
values.
the lookup table array is 2 colums x 9903 rows, sorted by the first
column.
is there a restriction on the size of the lookup table array?
Thanks
Ken

I don't think so. Post your formula and details of the lookup value and
returned data you are expecting, and what you actually get.

In the example below, the lookup in C2 should be returning 462380, but it is
returning 461380. The actual lookup in on another sheet and 9000 rows, but
this is the type of error I am getting
Thanks
Ken

A B C
1 Pool loan # =VLOOKUP(B2,A7:B10,2)
2 Pool_05 28846970 461380
3 Pool_05 17685371 461380
4 Pool_05 21455829 461380
5 Pool_05 21457320 461380
6
7 Loan # Pool Number
8 28846970 462104
9 28847036 462103
10 28847044 462103


"Stephen" wrote:

"ken gault" wrote in message
...
I am using a vlookup that is returning a wrong value. all of the data are
numeric, I have checked for spaces, text and used paste special for
values.
the lookup table array is 2 colums x 9903 rows, sorted by the first
column.
is there a restriction on the size of the lookup table array?
Thanks
Ken

I don't think so. Post your formula and details of the lookup value and
returned data you are expecting, and what you actually get.

You need to look for an exact match, which means you should use a
fourth parameter in the VLOOKUP formula and set it to 0 (or FALSE),
like so:

=VLOOKUP(B2,A$7:B$10,2,0)

Don't forget to make the row references of your lookup table into
absolute before you copy it down.

Hope this helps.

Pete

On Nov 16, 7:49 pm, ken gault
wrote:
In the example below, the lookup in C2 should be returning 462380, but it is
returning 461380. The actual lookup in on another sheet and 9000 rows, but
this is the type of error I am getting
Thanks
Ken

A B C
1 Pool loan # =VLOOKUP(B2,A7:B10,2)
2 Pool_05 28846970 461380
3 Pool_05 17685371 461380
4 Pool_05 21455829 461380
5 Pool_05 21457320 461380
6
7 Loan # Pool Number
8 28846970 462104
9 28847036 462103
10 28847044 462103



"Stephen" wrote:
"ken gault" wrote in message
...
I am using a vlookup that is returning a wrong value. all of the data are
numeric, I have checked for spaces, text and used paste special for
values.
the lookup table array is 2 colums x 9903 rows, sorted by the first
column.
is there a restriction on the size of the lookup table array?
Thanks
Ken

I don't think so. Post your formula and details of the lookup value and
returned data you are expecting, and what you actually get.- Hide quoted text -

- Show quoted text -