Vlookup 1 column off

[bobkap]

Using this formula below, where D15 =99, I get the data back EXCEPT it is always one column to the left from where it should be. I SHOULD get $1.40 but I get $1.60 every time. Any help would be most appreciated.

=VLOOKUP(A6,bk,MATCH(D15,bkt,1))

Here's what the data looks like:

Part	13	25	37	48	73	101	145	201	289	600	750	1009
DMG1	$ 4.10	$ 2.85	$ 2.85	$ 1.90	$ 1.55	$ 1.35	$ 1.25	$ 0.95	$ 0.85	$ 0.75	$ 0.75	$ 0.65
DMG2	$ 5.30	$ 3.75	$ 2.85	$ 2.65	$ 2.10	$ 1.80	$ 1.65	$ 1.25	$ 1.10	$ 0.90	$ 0.90	$ 0.75
DMG3	$ 7.05	$ 4.60	$ 4.60	$ 3.45	$ 2.65	$ 2.15	$ 1.90	$ 1.50	$ 1.25	$ 1.05	$ 1.05	$ 0.90
DMG4	$ 8.05	$ 5.95	$ 5.95	$ 4.10	$ 3.20	$ 2.45	$ 2.30	$ 1.75	$ 1.40	$ 1.20	$ 1.20	$ 1.00
FE1	$ 2.25	$ 2.25	$ 1.60	$ 1.60	$ 1.40	$ 1.40	$ 1.20	$ 1.20	$ 1.00	$ 0.95	$ 0.95	$ 0.90
FE2	$ 2.35	$ 2.35	$ 1.80	$ 1.80	$ 1.55	$ 1.55	$ 1.40	$ 1.40	$ 1.05	$ 1.00	$ 1.00	$ 0.95
FE3	$ 2.55	$ 2.55	$ 2.00	$ 2.00	$ 1.70	$ 1.70	$ 1.60	$ 1.60	$ 1.10	$ 1.05	$ 1.05	$ 1.00
FE4	$ 2.75	$ 2.75	$ 2.20	$ 2.20	$ 1.85	$ 1.85	$ 1.75	$ 1.75	$ 1.15	$ 1.10	$ 1.10	$ 1.05
HTECH1	$ 2.88	$ 1.77	$ 1.77	$ 1.77	$ 1.14	$ 1.14	$ 0.91	$ 0.91	$ 0.78	$ 0.66	$ 0.60	$ 0.55
HTECH2	$ 4.60	$ 2.25	$ 2.25	$ 2.25	$ 1.43	$ 1.43	$ 1.28	$ 1.28	$ 1.02	$ 0.84	$ 0.76	$ 0.69
HTECH3	$ 6.66	$ 2.74	$ 2.74	$ 2.21	$ 1.71	$ 1.62	$ 1.62	$ 1.62	$ 1.27	$ 1.02	$ 0.93	$ 0.84
HTECH4	$ 8.05	$ 3.11	$ 3.11	$ 2.50	$ 2.04	$ 2.04	$ 1.98	$ 1.98	$ 1.51	$ 1.20	$ 1.09	$ 0.98

 

[bebo021999]

Not sure what is bkt range name and bk range name, but try:

=VLOOKUP(A6,bk,MATCH(D15,bkt,1)+1)

 

[Alex Blakenburg]

As bebo mentioned it depends very much on your named ranges. Ideally you want the start and end columns of both ranges to be the same.
So if bk starts at A then bkt should start at A.

PS: its not a good idea to have range names that can be interpreted to be Column references, with Columns going out to XFD both your range names would be viable as column references.