Price List VLookup

C

cbass1856

New Member
Joined
May 29, 2008
Messages
5
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 all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
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))
 
Upvote 0
cbass1856 said:
The products they can choose from is in a drop down format.

Cbass1856
Click to expand...

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.
 
Upvote 0
Gene Khalyapin said:
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.
Click to expand...

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!
 
Upvote 0
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 :)->)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Create Function that Calculates a Value Relative to Original Price and Also Constructs a Price Ladder
2
Replies
10
Views
862
NdNoviceHlp
NdNoviceHlp
O
  • Question
Vlookup with multiple conditions
2
Replies
10
Views
750
kweaver
kweaver
M
  • Question
Rework of existing formula
Replies
0
Views
265
mclark15
M
J
  • Solved
Formula to Replace Text with Numerical Value (if this, then that?) from VLOOKUP
Replies
5
Views
1K
Toadstool
Toadstool
C
  • Question
Need help with look up formula
Replies
5
Views
423
GuzmanServices
G

Forum statistics

Threads
1,214,382
Messages
6,119,194
Members
448,874
Latest member
Lancelots

Share this page

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