# Table vlookup

#### JohnWood

##### New Member
Hello. I cannot find a solution for work, for finding a certain value of parts and labours percentage for a certain defect code, mileage and months since fabrication. In the interogation table i put defect code, vehicle, mileage and months since fabrication and i have to find the coresponding parts and labour percentage. Thanks

Interogation sheet:
Defect Code
Vehicle/engine
Fabrication
Mileage
Parts
Labour.

The shhet where i m looking for values
 Defect Code Vehicle/engine Limit Months since fabrication Limit Mileage Labour % Parts % 371299 h07, h11 48 150 000 50 100 198992 k63 36 150 000 50 100 198992 k63 48 150 000 0 100 111111 k63 36 150 000 50 100 111111 k63 48 150 000 0 100 111227 k63 36 150 000 50 100 111227 k63 48 150 000 0 100 111227 p47, p57, k47, k57 60 150 000 100 100 111593 k63 36 150 000 50 100 111593 k63 48 150 000 0 100 113193 k43, k47, k47T, k47S, k47DK0, all derivates 84 200 000 100 100 113197 k43 60 200 000 80 100 113197 k43 60 200 000 80 100 113791 k52K, k52T, k55 60 100 000 100 100 114199 k57 60 100 000 100 100 117595 k47 60 150 000 100 100 117595 all derivates 84 150 000 100 100 135175 all derivates 60 150 000 100 100 135175 all derivates 72 150 000 0 100 135322 all derivates 72 150 000 100 100 171494 h20, 21, 22, 30, 31, 32, 33, 34, 35, 36, k13, 20, 26, 55 60 120 000 100 100 171199 k52T, k53 48 100 000 100 100 271999 k47 k57 48 150 000 100 100 271999 k47 k57 60 150 000 0 100 411393 E70, E71, E72 all ekgikes 120 No limit 100 100 712199 5, 6, 7-Ser, X5 , X6 48 200 000 100 100 713725 h07, h11 48 No limit 100 100 745392 h01, h02, h03, h07, h10, h11, h12, h13, h18 36 150 000 100 100 11129377 p47, p57, k47, k57 60 150 000 100 100 11319391 k47 120 250 000 100 100 11349977 p47, p57, k47, k57 60 150 000 100 100 11711277 p47, p57, k47, k57 60 150 000 100 100 17119979 h06, h07, h10, h11, h12, h13, h18, E70, E71 all 120 No limit 100 100 7135992299 cas 72 No limit 100 100

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
?!

Replies
5
Views
520
Replies
0
Views
143
Replies
4
Views
359
Replies
7
Views
241
Replies
0
Views
481

1,196,235
Messages
6,014,146
Members
441,807
Latest member
sjkenjalo

### 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