Vlookup 2 matching values

eastern promise

New Member
Joined
Mar 18, 2019
Messages
2
Hello,

I am trying create a vlookup that will match values.

For example match the values in A2 and B2, find them in Sheet1 range (a14:p257) and return the value in column 4
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

eastern promise

New Member
Joined
Mar 18, 2019
Messages
2
Hi There,

See below

ABC
1314Cleaning"Match 314 & Cleaning in Sheet 2 and return the value in Sheet2 C1"
2314Cleaning Admin
3320Window Cleaning
4313Hygiene Services & Toiletries
5314Towels & Handryers
6316Pest Control
7318Snow Clearance & Gritting
8314Sundries Housekeeping (Consumables)

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1



ABCDEFGHIJ
1314Cleaning0.64620.30.02350.0303
2314Cleaning Admin0.64620.30.02350.0303
3320Window Cleaning0.64620.30090.02350.0294
4313Hygiene Services & Toiletries 0.44420.26460.06230.2289
5314Towels & Handryers0.64620.30090.02350.0294
6316Pest Control0.44420.26460.06230.2289
7318Snow Clearance & Gritting0.64620.30090.02350.0294
8314Sundries Housekeeping (Consumables)0.64620.30090.02350.0294
9450Outside0.44420.26460.06230.2289
10450Cleaning Admin0.64620.30.02350.0303
11455Window Cleaning0.64620.30.02350.0303
12450Hygiene Services & Toiletries 0.64620.30090.02350.0294
13433Towels & Handryers0.44420.26460.06230.2289
14450Pest Control0.64620.30090.02350.0294
15660Snow Clearance & Gritting0.44420.26460.06230.2289
16450Sundries Housekeeping (Consumables)0.64620.30090.02350.0294
170.64620.30090.02350.0294
180.44420.26460.06230.2289

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
73,212
Office Version
  1. 365
Platform
  1. Windows
How about


Excel 2013/2016
ABC
2314Cleaning0.6462
3314Cleaning Admin0.6462
4320Window Cleaning0.6462
5313Hygiene Services & Toiletries0.4442
6314Towels & Handryers0.6462
7316Pest Control0.4442
8318Snow Clearance & Gritting0.6462
9314Sundries Housekeeping (Consumables)0.6462
Data
Cell Formulas
RangeFormula
C2{=INDEX(Sheet2!$C$2:$C$19,MATCH(A2&B2,Sheet2!$A$2:$A$19&Sheet2!$B$2:$B$19,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,016
Messages
5,834,943
Members
430,327
Latest member
Mr_Himalayan778

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
Top