# Price List VLookup

#### cbass1856

##### New Member
Hello,
I have been attenpting this for two days now and hopefully someone can help. We put together a pricing list in excel. The products they can choose from is in a drop down format. When they select a product and populate the qty the price will display. The problem being we have 4 different prices based on their buying qty.

Products 1Site 2 - 4 5 - 7 8 or more
T&M Labor \$1800 \$1500 \$1200 \$1000
T&M Equipment \$300 \$250 \$200 \$150
T&M Materials \$300 \$200 \$175 \$100
LS \$300 \$200 \$175 \$100
UP \$300 \$200 \$175 \$100

So if they choose Time and Materials Labor qty3 it should choose 186,000 and multiply it by three. I have been able to get one look up to work using this formula
= IF(B5=1,VLOOKUP(A5,'DO NOT TOUCH'!A23:B27,2,FALSE))
But this only works for the first column. When I try to add other criteria the formul fails. Is there a way to set up an IF statement with a vlookup that can select the proper price based on the product and its corresponding qty? And then finally take the value and multiply it by the Qty Site Quantity field Any help you could would be greatly appreciated. Thanks in advance for your help.

Cbass1856

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Xelas

##### New Member
With a sheet like this:
Code:
``````                                                                                                                                                <table style="border-collapse: collapse; width: 352pt;" border="0" cellpadding="0" cellspacing="0" width="467"><col style="width: 48pt;" width="64"> <col style="width: 87pt;" width="116"> <col style="width: 53pt;" span="3" width="70"> <col style="width: 58pt;" width="77"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" height="17" width="64">
</td> <td style="width: 87pt;" align="center" width="116">A</td> <td style="width: 53pt;" align="center" width="70">B</td> <td style="width: 53pt;" align="center" width="70">C</td> <td style="width: 53pt;" align="center" width="70">D</td> <td style="width: 58pt;" align="center" width="77">E</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">1</td> <td>Products</td> <td align="center">1</td> <td align="center">2-4</td> <td align="center">5-7</td> <td align="center">=>8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">2</td> <td>T&M Labor</td> <td class="xl65" align="right">1800</td> <td class="xl65" align="right">1500</td> <td class="xl65" align="right">1200</td> <td class="xl65" align="right">1000</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">3</td> <td>T&M Equipment </td> <td class="xl65" align="right">300</td> <td class="xl65" align="right">250</td> <td class="xl65" align="right">200</td> <td class="xl65" align="right">150</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">4</td> <td>T&M Materials </td> <td class="xl65" align="right">300</td> <td class="xl65" align="right">250</td> <td class="xl65" align="right">200</td> <td class="xl65" align="right">150</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">5</td> <td>LS </td> <td class="xl65" align="right">300</td> <td class="xl65" align="right">250</td> <td class="xl65" align="right">200</td> <td class="xl65" align="right">150</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">6</td> <td>UP </td> <td class="xl65" align="right">300</td> <td class="xl65" align="right">250</td> <td class="xl65" align="right">200</td> <td class="xl65" align="right">150</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">7</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">8</td> <td align="center">product</td> <td align="center">qty</td> <td align="center">price</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" align="left" height="17">9</td> <td>T&M Labor</td> <td align="right">8</td> <td align="right">8000</td> <td>
</td> <td>
</td> </tr> </tbody></table>``````
The code for total price in C9 is:
=B9*OFFSET(\$A\$2,MATCH(A9,\$A\$2:\$A\$6,0)-1,5-MATCH(B9,{1000000000,7,4,1},-1))

#### Gene Khalyapin

##### New Member
The products they can choose from is in a drop down format.

Cbass1856

If you select the product from a drop-down menu and then fill in the quantity, then this formula will work better as it will locate the needed product and then based on the specified quantity will return the set price per unit:

=INDEX(\$B\$3:\$E\$7,MATCH(\$A13,\$A\$3:\$A\$7,0),MATCH(B13,\$B\$1:\$E\$1,1))

<TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0><COLGROUP><COL style="WIDTH: 106pt; mso-width-source: userset; mso-width-alt: 5156" width=141><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><TBODY><TR style="HEIGHT: 12pt" height=16><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: transparent" width=141 height=16>Min Order</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" align=right width=75>1</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" align=right width=73>2</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" align=right width=75>5</TD><TD class=xl72 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" align=right width=75>8</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>Products</TD><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>1</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=73>2-4</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>5-7</TD><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>=>8</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>T&M Labor</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>1800</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=73>1500</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>1200</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>1000</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>T&M Equipment</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>300</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=73>250</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>200</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>150</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>T&M Materials</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>300</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=73>250</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>200</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>150</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>LS</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>300</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=73>250</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>200</TD><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=75>150</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl74 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 106pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=141 height=20>UP</TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>300</TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 55pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=73>250</TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>200</TD><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=75>150</TD></TR></TBODY></TABLE>

I used colors to show what ranges the formula refer to (is there a way to post an Excel file? It would be easier to see)
In this scenario, A13 is going to have the product input, B13 is going to have quantity and the formula, entered in C13, will return the result (price per unit). You can add one more column multiplying quantity by price per unit for a total price.

I will post the excel file if I find the way to do it.

#### Xelas

##### New Member
If you select the product from a drop-down menu and then fill in the quantity, then this formula will work better as it will locate the needed product and then based on the specified quantity will return the set price per unit:

=INDEX(\$B\$3:\$E\$7,MATCH(\$A13,\$A\$3:\$A\$7,0),MATCH(B13,\$B\$1:\$E\$1,1))

<table style="width: 329pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="439"><colgroup><col style="width: 106pt;" width="141"><col style="width: 56pt;" width="75"><col style="width: 55pt;" width="73"><col style="width: 56pt;" span="2" width="75"></colgroup><tbody><tr style="height: 12pt;" height="16"><td class="xl66" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; width: 106pt; height: 12pt; background-color: transparent;" height="16" width="141">Min Order</td><td class="xl72" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; width: 56pt; background-color: transparent;" align="right" width="75">1</td><td class="xl72" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; width: 55pt; background-color: transparent;" align="right" width="73">2</td><td class="xl72" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; width: 56pt; background-color: transparent;" align="right" width="75">5</td><td class="xl72" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 1pt; width: 56pt; background-color: transparent;" align="right" width="75">8</td></tr><tr style="height: 15pt;" height="20"><td class="xl65" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">Products</td><td class="xl68" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">1</td><td class="xl69" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 55pt; background-color: transparent;" width="73">2-4</td><td class="xl69" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">5-7</td><td class="xl68" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">=>8</td></tr><tr style="height: 15pt;" height="20"><td class="xl73" style="border: medium none rgb(236, 233, 216); width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">T&M Labor</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">1800</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 55pt; background-color: transparent;" width="73">1500</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">1200</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">1000</td></tr><tr style="height: 15pt;" height="20"><td class="xl73" style="border: medium none rgb(236, 233, 216); width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">T&M Equipment</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">300</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 55pt; background-color: transparent;" width="73">250</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">200</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">150</td></tr><tr style="height: 15pt;" height="20"><td class="xl73" style="border: medium none rgb(236, 233, 216); width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">T&M Materials</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">300</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 55pt; background-color: transparent;" width="73">250</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">200</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">150</td></tr><tr style="height: 15pt;" height="20"><td class="xl73" style="border: medium none rgb(236, 233, 216); width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">LS</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">300</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 55pt; background-color: transparent;" width="73">250</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">200</td><td class="xl70" style="border: medium none rgb(236, 233, 216); width: 56pt; background-color: transparent;" width="75">150</td></tr><tr style="height: 15pt;" height="20"><td class="xl74" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 106pt; height: 15pt; background-color: transparent;" height="20" width="141">UP</td><td class="xl71" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">300</td><td class="xl71" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 55pt; background-color: transparent;" width="73">250</td><td class="xl71" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">200</td><td class="xl71" style="border-style: none none solid; border-color: rgb(236, 233, 216) rgb(236, 233, 216) windowtext; border-width: medium medium 0.5pt; width: 56pt; background-color: transparent;" width="75">150</td></tr></tbody></table>

I used colors to show what ranges the formula refer to (is there a way to post an Excel file? It would be easier to see)
In this scenario, A13 is going to have the product input, B13 is going to have quantity and the formula, entered in C13, will return the result (price per unit). You can add one more column multiplying quantity by price per unit for a total price.

I will post the excel file if I find the way to do it.

I like the formatting. Nice.

Or Use =B13*INDEX(\$B\$3:\$E\$7,MATCH(\$A13,\$A\$3:\$A\$7,0),MATCH(B13,\$B\$1:\$E\$1,1)) to get the total price.

Thanks!

#### Gene Khalyapin

##### New Member
I still don't know if it's possible to post an Excel file in this forum... I thought the colors would help read the formula better ->)

#### cbass1856

##### New Member
Thanks for all the help. That worked like a charm.

Cbass

Replies
10
Views
469
Replies
0
Views
138
Replies
5
Views
845
Replies
6
Views
539
Replies
11
Views
314

1,191,383
Messages
5,986,307
Members
440,017
Latest member
vasanrajeswaran

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