# Vlookup question

#### TJMMARTELLA

##### Board Regular
I am using a formula [=VLOOKUP(A10,[grid.xls]Inventory!\$1:\$65536,9,FALSE) and it's returning "inaccurate" information.

i.e. i'm referencing #3202 and i'm getting results for #13202.

It was my understanding that "false" in the formula, dicatates only exact matches. any help would be appreciated. Thanks.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### MrKowz

##### Well-known Member
What you say is correct, FALSE should return ONLY EXACT matches... that is very odd that it is returning inaccurate info. The solution is by me...

#### ravishankar

##### Well-known Member
Hi
Inventory!\$1:\$65536,9, This portion of the formula shows 9th column to be picked .But range does not show which col. (B1:J65536)
Ravi

#### Yogi Anand

##### MrExcel MVP
Hi
Inventory!\$1:\$65536,9, This portion of the formula shows 9th column to be picked .But range does not show which col. (B1:J65536)
Ravi

Hi Ravi:

Reference to the LookUp range as \$1:\$65536, in versions of EXCEL earlier than 2007 would mean refering to range of columns A:IV -- so that part is OK.

I suggest OP post part of the data showing the LookUp value , the LookedUp value so one can see what is going on here.

#### Guanjin Peter

##### Active Member
just a suggestion: using 65536...isn't that dangerous? It'll create alot of lag? why not place with a variable 65536?

say max rows is 10,000
you can use countA to determine the max number of rows.
[=VLOOKUP(A10,[grid.xls]Inventory!\$1:\$10000,9,FALSE)

Last edited:

Replies
1
Views
260
Replies
2
Views
533
Replies
7
Views
293
Replies
7
Views
1K
Replies
10
Views
860

1,191,395
Messages
5,986,357
Members
440,019
Latest member
Natalie12138

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back