# pricing

1. ### Getting Specific Rates for Certain Cell Conditions (Logistics)

Hello All, Firstly, I'm glad to be a member on this community and excited to have my first post. Here's my query: So I wanted column F to auto populate the CWT rate for our shipments. This column F would at least show how much cwt the carrier "column E" would charge us for that weight...
2. ### Vlookup Indirect and Match function error

Hi all, I would like the formula to find the pricing across multiple tabs and the problem is the pricing column. The pricing column is situated on a different column letter on each tab. Would it be possible to replace the 1 from the formula to a match function? like the formula below...
3. ### Quote Creation Document - Requiring double lookup

Hi Would anyone be able to help me? I am trying to create a document that will auto populate from an excel sheet with product and pricing, sheet 1 is the quote template, with sheet 2 being the data behind. Sheet 1 - Quote template <tbody> D EFGH I J K 12 Product Desc Qty Unit Price total...
4. ### VLOOKUP - Questions

Hey guys, I'm currently trying to create a "cheat sheet" for some Pricing. Currently, "Sheet1" looks like this. I have each column represented for the Size/Style/Price/Date. <tbody> Size Style Price Date 24 x 42 Harvey 2 42.88 4-12-19 30 x 42 Harvey 2 45.05 4-12-19 42 x 42 Harvey 2 52.58...
5. ### Auto Fill cell with information from Table

Hey, I'm working on a job cost form to price things for my business. On the job cost form I have it set up as follows: <tbody> Size Shape Color Qty Unit Cost 5" Round Red 5 \$0.07 11" Round Red 10 \$0.15 </tbody> I also have a sheet that has the pricing data from my main supplier. it...
6. ### Formula to input product pricing based on multiple factors

Man I hope I explain this correctly... I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on...
7. ### Aggregate Function's Array Argument Gives VOLATILE formula result when using concatenation for Named Range

Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...
8. ### Formula needed for volume discount pricing

Hi everyone, I own a printing business and there are a TON of variables in print pricing lol. So I need a formula for multi-page booklets (like catalogs) Basically I will put a formula in that will come up with the number of prints it will take to make a multi-page booklet and I need the...
9. ### Pricing comparison

hey; i need your help; i have a sheet containing 500 types of equipment each equipment has 2 or three prices and i need to get from it the min price , average and max prices and returning the supplier name for each value
10. ### Send Email and Log Date Sent

Experts, I am working on a way to use excel to send out an order form on worksheet "Printer Pricing" and am using a drop down list from a second worksheet named "Master Data". The drop down on "Printer Pricing" populates ship to address and other contact information using vlookup referencing...
11. ### need help updating new prices

I'm trying to pull pricing from a separate workbook. Not all part numbers are included in the new pricing, just the updated ones. Closest I've gotten is the formula below but I don't want a blank when false, I want the old but still current price to remain...
12. ### Incorrect value picked up in Vlookup across multiple columns in one formula

Hi All, I was trying to vlookup my data from a table with 4 columns, when I applied the following formula there were errors in a few of the calculations. IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing Chart'!\$B\$4:\$I\$34,2,1),IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing...
13. ### Clear Contents In VB

Hello all! New to VB and have a question. I'm trying clear contents in one cell once a drop down is selected. I select a drop down that displays pricing in the the "System Pump" and "VFD Pricing " Cells. What I'd like it to do is clear just the contents in (VFD Pricing \$) once "NO" is...
14. ### Progressive Pricing Formula

Hope you can help!! I have a progressive pricing formula I need help with, been tearing my hair out Each band gets individual earnings in steps apart from <10 that gets nothing. In the below example customer sells 35 baskets, so will reach the 4th band. Band 1 - Zero Band 2 - 10 * £1.15 =...
15. ### Formula Question in Macro

my end goal is thatevery month you run the macro and get : "**this month** pricing" and"**next month** pricing" I get an #Name error when I run this. =MONTHNAME()&" Price" Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("U1").Select...
16. ### Help with a formula

Could anybody help me out with a formula to work out some tiered pricing. Assume that I have my pricing structure in cells A1:A5 as follows; A1=£250, A2=£200, A3=£150, A4=£100, A5=£50. In cells B1:B5 I have the volume at which that price kicks in; B1=<50, B2=50-80, B3=80-100, B4=100-120...
17. ### Weighted Average with Two Weighting Criteria

Thanks for your help in advance... I have to figure out pricing, using a weighted average. But I have two Weighting Criteria. Dates & Distance (Fractions of a Mile). <colgroup><col><col><col></colgroup><tbody> Date of Sale Distance Pricing 11/6/2017 0.12 654.36 7/11/2018 0.21 765.31...
18. ### how to updating product tables with new yearly pricing - MS 2013

Hi all I've been using this guide http://web.pdx.edu/~gerbing/325/Resources/Access.pdf which gives reasonable instructions to setup a simple invoicing database, which I've done. https://drive.google.com/open?id=1hLO41QMUGE6vL-76qIQyT_d6ycZ8bVeo If i update the the product table with new...
19. ### Rerouting links between two worksheets in a workbook. Excel 2010

I'm updating a workbook someone else created a couple years ago and there are two incidences of worksheets that are identical except that Sheet 1 has the Item, Description and pricing info and Sheet 2 has Item and Description but links back to the first one for pricing info. The main sheet...
20. ### Vlookup in dynamic workbooks

Hi I am trying to get a Vlookup funktion to work in a pricing worksheet. The sheet is going to be a template, so the customer account number will change with every use. For each item, i need to lookup a discount value in a pricing file.. The file is named as the account no, ex. "3720.xlsm"...

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