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
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

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
46,303
Office Version
  1. 365
Platform
  1. Windows
How about

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">314</td><td style=";">Cleaning</td><td style="text-align: right;;">0.6462</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">314</td><td style=";">Cleaning Admin</td><td style="text-align: right;;">0.6462</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">320</td><td style=";">Window Cleaning</td><td style="text-align: right;;">0.6462</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">313</td><td style=";">Hygiene Services & Toiletries</td><td style="text-align: right;;">0.4442</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;">314</td><td style=";">Towels & Handryers</td><td style="text-align: right;;">0.6462</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;">316</td><td style=";">Pest Control</td><td style="text-align: right;;">0.4442</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;">318</td><td style=";">Snow Clearance & Gritting</td><td style="text-align: right;;">0.6462</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;">314</td><td style=";">Sundries Housekeeping (Consumables)</td><td style="text-align: right;;">0.6462</td></tr></tbody></table><p style="width:3.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Data</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C2</th><td style="text-align:left">{=INDEX(<font color="Blue">Sheet2!$C$2:$C$19,MATCH(<font color="Red">A2&B2,Sheet2!$A$2:$A$19&Sheet2!$B$2:$B$19,0</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
 

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,062
Members
409,684
Latest member
Nazmul00

This Week's Hot Topics

Top