Table vlookup

JohnWood

New Member
Joined
Dec 2, 2014
Messages
28
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 CodeVehicle/engineLimit Months since fabricationLimit Mileage Labour % Parts %
371299h07, h1148150 00050100
198992k6336150 00050100
198992k6348150 0000100
111111k6336150 00050100
111111k6348150 0000100
111227k6336150 00050100
111227k6348150 0000100
111227p47, p57, k47, k57 60150 000100100
111593k6336150 00050100
111593k6348150 0000100
113193 k43, k47, k47T, k47S, k47DK0, all derivates 84200 000100100
113197k4360200 00080100
113197k4360200 00080100
113791k52K, k52T, k5560100 000100100
114199k5760100 000100100
117595k4760150 000100100
117595all derivates84150 000100100
135175 all derivates 60150 000100100
135175 all derivates 72150 0000100
135322 all derivates 72150 000100100
171494h20, 21, 22, 30, 31, 32, 33, 34, 35, 36, k13, 20, 26, 5560120 000100100
171199k52T, k5348100 000100100
271999k47 k5748150 000100100
271999k47 k5760150 0000100
411393E70, E71, E72 all ekgikes120No limit100100
7121995, 6, 7-Ser, X5 , X648200 000100100
713725h07, h1148No limit100100
745392h01, h02, h03, h07, h10, h11, h12, h13, h1836150 000100100
11129377p47, p57, k47, k57 60150 000100100
11319391k47120250 000100100
11349977p47, p57, k47, k57 60150 000100100
11711277p47, p57, k47, k57 60150 000100100
17119979h06, h07, h10, h11, h12, h13, h18, E70, E71 all120No limit100100
7135992299cas72No limit100100

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

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

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top